countif
 

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,

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,