Thread
:
countif
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
countif
=sumproduct((a2:a22="bill")*(b2:b22="jones"))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"mikesteven" wrote in message
...
I have first names listed is column "A" and last names listed in column
"B".
I have a counif statement in column "C" giving me a total count of each
name
using last name. Example-countif(B2:B300,"jones"). I have run into a
problem
where people have the same last name and now I need to use the first name
with the last name to get the count. How can I set up my counif statement
to
use the first and last name and then give me a count total. I tried
countif(B2:B300,"jones")+ countif(a2:a300,"steve"). This did not work. Any
help would be appreciated.
Thanks,
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett