Sumproduct and the darn dates!

[Kreller]

Hi,

I'm a newbie in sumproducts but have found it very functional. However
I have a probelem with using a data as criteria in an array. The formul
doesn't work when testing for the date (in the example 18-10-2004), bu
when I test the formula with anything else - e.g. a text string - i
works well.

=SUMPRODUCT(--(N2:N1000="Meeting");--(O2:O1000="18-10-2004"))

I was proposed the solution with DATEVALUE

=SUMPRODUCT(--(N2:N1000="Meeting");--(O2:O1000=DATEVALUE("18-10-2004")))

but it doesn't work either.

Any suggestions?

 

[Don Guillett]

I have found the easiest way to do this is refer to a cell with the date
desired.
o21000=d1