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