countifand
=SUMPRODUCT((A1:A100="Adams")*(B1:B100="John"))
HTH
Kostis Vezerides
On Dec 21, 9:01 pm, tonyalt3 wrote:
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.
|