countifand
=SUMPRODUCT((A1:A100="Adams")*(B1:B100="John"))
--
David Biddulph
"tonyalt3" wrote in message
...
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.
|