Thread: countifand
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tonyalt3 tonyalt3 is offline
external usenet poster
 
Posts: 20
Default countifand

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.