Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting two columns with specific criteria
In column A I have a list of FIRST names and in column B I have a list
of LAST names. How can I count the number of people with "SMITH" as the LAST name ONLY if they have "BOB" as a FIRST name? I have a tried a few things but have got a bit of brain freeze... Any suggestions? Thanks Richard |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting two columns with specific criteria
Hi,
Try this =SUMPRODUCT((A1:A20="Bob")*(B1:B20="Smith")) Mike "rjre" wrote: In column A I have a list of FIRST names and in column B I have a list of LAST names. How can I count the number of people with "SMITH" as the LAST name ONLY if they have "BOB" as a FIRST name? I have a tried a few things but have got a bit of brain freeze... Any suggestions? Thanks Richard |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting two columns with specific criteria
THANKS!
i had no idea i that function worked on text! FANTASTIC! On Feb 13, 11:09*am, Mike H wrote: Hi, Try this =SUMPRODUCT((A1:A20="Bob")*(B1:B20="Smith")) Mike "rjre" wrote: In column A I have a list of FIRST names and in column B I have a list of LAST names. How can I count the number of people with "SMITH" as the LAST name ONLY if they have "BOB" as a FIRST name? I have a tried a few things but have got a bit of brain freeze... Any suggestions? Thanks Richard- Hide quoted text - - Show quoted text - |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting two columns with specific criteria
Glad I could help
"rjre" wrote: THANKS! i had no idea i that function worked on text! FANTASTIC! On Feb 13, 11:09 am, Mike H wrote: Hi, Try this =SUMPRODUCT((A1:A20="Bob")*(B1:B20="Smith")) Mike "rjre" wrote: In column A I have a list of FIRST names and in column B I have a list of LAST names. How can I count the number of people with "SMITH" as the LAST name ONLY if they have "BOB" as a FIRST name? I have a tried a few things but have got a bit of brain freeze... Any suggestions? Thanks Richard- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching two columns against a specific criteria | Excel Worksheet Functions | |||
Summing specific Columns based on Criteria | Excel Discussion (Misc queries) | |||
Sum rows if two columns = specific criteria. | Excel Worksheet Functions | |||
Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions | |||
Counting columns and specific Dates | Excel Worksheet Functions |