K
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
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