View Single Post
  #1   Report Post  
BRIAN BRIAN is offline
Junior Member
 
Posts: 3
Default Dont know what to use.

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.

Last edited by BRIAN : January 25th 06 at 01:55 AM