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!D1
500=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