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