I'd use:

=sumproduct(--(al3:al84=date(2006,3,1)),--(ap3:ap84=6))

And ap3:ap84 contains the number 6, not the string '6 (as text), right?

Barb Reinhardt wrote:

What am I doing wrong he

=SUMPRODUCT(AL3:AL84="3/1/2006")*(AP3:AP84=6)

I want to count the number of times AL3:AL84 = 3/1/2006 AND AP3:AP84 = 6.
I keep getting ZERO when this is a non zero number. I have entered it with
CTRL SHIFT ENTER (I think that's it) and it has {} around it.

Thanks,
Barb Reinhardt

--

Dave Peterson