countif

[mikesteven]

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,

 

[Don Guillett]

=sumproduct((a2:a22="bill")*(b2:b22="jones"))