count if help

[thepartydj]

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]

[VBA]=IF(A9="joe",COUNTIF(Activations!P:P,I9),0)[/VBA]

[mdmackillop]

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))