PDA

View Full Version : count if help



thepartydj
02-14-2007, 09:07 AM
I currently have the following formula
=COUNTIF(Activations!P:P,I9)

This takes what is in I9 (mailing) and adds how many times that word shows up in column P on my activations sheet.

I want to add something to that

I want it to do the following:
Look at I9 and count how many times it show up in column P but only if column A matches "joe"

what do I need to change/add to make that work? Thank You!

gnod
02-14-2007, 09:35 AM
=IF(A9="joe",COUNTIF(Activations!P:P,I9),0)

mdmackillop
02-14-2007, 10:02 AM
Depends where Joe lives; either
=SUMPRODUCT(--($A$1:$A$2000="Joe"),--(Activations!$P$1:$P$2000=$I$9))
or
=SUMPRODUCT(--(Activations!$A$1:$A$2000="Joe"),--(Activations!$P$1:$P$2000=$I$9))