PDA

View Full Version : [SOLVED] SUMPRODUCT help



lifeson
04-07-2009, 04:33 AM
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"))

Bob Phillips
04-07-2009, 04:43 AM
Try


=SUMPRODUCT(--(Dates=--"2009-03-21"),--(Venues="Stockport"))

lifeson
04-07-2009, 07:46 AM
Thanks XLD
Too many '-----' for me to have worked out !

Bob Phillips
04-07-2009, 08:07 AM
You could also have used


=SUMPRODUCT(--(Dates=Date(2009,03,21)),--(Venues="Stockport"))

or even



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