Try this...

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

Where n = the quarter number 1 to 4.

--
Biff
Microsoft Excel MVP


"KC" wrote in message
...
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