Hello:

I think that the following is incorrect:
--(MONTH(Hiring!T1:T500=3)))

Try

--(MONTH(Hiring!T1:T500)=3))

ie

SUMPRODUCT(--(Hiring!U1:U500=A3),--(Hiring!D1500=B2),--(MONTH(Hiring!T1:T500)=3))

--
Hope this helps
Martin Fishlock, www.nyfconsultants.com, Wolverhampton, UK
Please do not forget to rate this reply.


"KC" wrote:

I'm trying to use the formula below, but its not working correctly. On the
Hiring tab, column T has a date formatted as MM/DD/YYYY. I want a formula
that counts the number of hires in a quarter with other criteria. So for
instance if column U = A3 (Cons) and column D = GMT and column T is in 1Q
(Jan thru March). I'll also need the same formula for 2Q (April thru June),
3Q & 4Q.

=SUMPRODUCT(--(Hiring!U1:U500=A3),--(Hiring!D1500=B2),--(MONTH(Hiring!T1:T500=3)))

A3=Cons
B2=GMT