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