| 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 | |||
Hybrid Mode
