Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |