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.

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.

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.

countifand
 

On Dec 21, 1:06*pm, vezerid wrote:
=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.- Hide quoted text -

- Show quoted text -

Perfect!!! Thanks