Problems with sumproduct and 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. Do you have a solution?

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

Thanks in advance

 

[papou]

Hi
Try
=SUMPRODUCT(--(N2:N1000="Meeting");--(O2:O1000=DATEVALUE("18-10-2004")))
HTH
Cordially
Pascal