Hi All
I have a problem with a SUMPRODUCT formula:

Attached is a workbook showing example data and I thought the following would work
Dates and Venues are named ranges

=SUMPRODUCT((Dates="21/03/2009")*(Venues="Stockport"))