software

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

In quot;Aquot; I have names and in quot;Hquot; I need to it count every time the term CFO is used. there is other data in quot;Hquot; also but I just want it to count the times I use the term CFO in quot;Hquot;

right now I am using this one
=SUMPRODUCT(--(Contacts!A5:A1983=quot;ANNIEquot;),--(Contacts!H5:H1983=quot;CFOquot;))

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=quot;ANNIEquot;),--(ISNUMBER(SEARCH(quot;CFOquot;,Contacts!H5:H1983))))

Biff

quot;BRIANquot; gt; wrote in message
...
gt;
gt; I need help makeing a forula that will count how many times i put a name
gt; in colum A and colum H
gt;
gt; In quot;Aquot; I have names and in quot;Hquot; I need to it count every time the term
gt; CFO is used. there is other data in quot;Hquot; also but I just want it to
gt; count the times I use the term CFO in quot;Hquot;
gt;
gt; right now I am using this one
gt; =SUMPRODUCT(--(Contacts!A5:A1983=quot;ANNIEquot;),--(Contacts!H5:H1983=quot;CFOquot;))
gt;
gt; but it only counts the cells that only have CFO, i need it to count the
gt; the cells that contain CFO.
gt;
gt; Thank you for any help.
gt;
gt;
gt; --
gt; BRIAN