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
|