Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|