countifand

  • Thread starter Thread starter tonyalt3
  • Start date Start date
T

tonyalt3

Is it possible to do a countifand function?
I have a list w/2 columns, last name (column A)/first name (column
B). I need to know how many times adams, john is listed, however
there are several people w/the last name Adams, so I can't just do a
Countif for Adams.
 
Back
Top