I need help makeing a forula that will count how many times i put a name in colum A and colum H

In "A" I have names and in "H" I need to it count every time the term CFO is used. there is other data in "H" also but I just want it to count the times I use the term CFO in "H"

right now I am using this one
=SUMPRODUCT(--(Contacts!A5:A1983="ANNIE"),--(Contacts!H5:H1983="CFO"))

but it only counts the cells that only have CFO, i need it to count the the cells that contain CFO.

Thank you for any help.

Hi!

Your post is very confusing!

Here's my best guess:

=SUMPRODUCT(--(Contacts!A5:A1983="ANNIE"),--(ISNUMBER(SEARCH("CFO",Contacts!H5:H1983))))

Biff

"BRIAN" wrote in message
...

I need help makeing a forula that will count how many times i put a name
in colum A and colum H

In "A" I have names and in "H" I need to it count every time the term
CFO is used. there is other data in "H" also but I just want it to
count the times I use the term CFO in "H"

right now I am using this one
=SUMPRODUCT(--(Contacts!A5:A1983="ANNIE"),--(Contacts!H5:H1983="CFO"))

but it only counts the cells that only have CFO, i need it to count the
the cells that contain CFO.

Thank you for any help.


--
BRIAN