countif

  • Thread starter Thread starter mikesteven
  • Start date Start date
M

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,
 
Back
Top