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"))
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"))
Try
=SUMPRODUCT(--(Dates=--"2009-03-21"),--(Venues="Stockport"))
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thanks XLD
Too many '-----' for me to have worked out !
You could also have used
or even=SUMPRODUCT(--(Dates=Date(2009,03,21)),--(Venues="Stockport"))
=SUMPRODUCT((Dates=Date(2009,03,21))*(Venues="Stockport"))
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber