| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count using multiple criteria including text strings
i have a spreadsheet where column b contains the title of the position,
column c contains the location and column d contains the name of the candidate. i need to count the number of candidates based on job title and location...each candidate has a unique name so i'm not sure how to make this happen. Staffing Mgr. Job Title Location Candidate Name Clare Duffin Sr. Marketing Mgr. Redmond, Wa Jesse Money Clare Duffin Sr. Marketing Mgr. Redmond, Wa Frank Kemery Clare Duffin Sr. Marketing Mgr. Redmond, Wa Chuck Mildes Clare Duffin Sr. Marketing Mgr. Redmond, Wa Kathleen Strom Clare Duffin Sr. Marketing Mgr. Redmond, Wa Susan Schutte Clare Duffin Sr. Marketing Mgr. Redmond, Wa Perry Anthony Clare Duffin Sr. Marketing Mgr. Redmond, Wa Susan Nguyen Sr. Marketing Mgr. Total Clare Duffin Sr. Content Mgr. Redmond, Wa Daniel Nolta Clare Duffin Sr. Content Mgr. Redmond, Wa Eric Neuman Clare Duffin Sr. Content Mgr. Redmond, Wa Jenni Grant Sr. Content Mgr. Total Is this possible? Thanks in advance for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i count specific text strings excluding blank cells? | Excel Worksheet Functions | |||
| How do I count frequency based on 2 criteria (including month) | Excel Worksheet Functions | |||
| Advanced Filter for multiple criteria, including blank cells | Excel Worksheet Functions | |||
| Count Cells That Don't Contain the Following Text Strings | Excel Discussion (Misc queries) | |||
| count text strings in an entire workbook | Excel Worksheet Functions | |||
Threaded Mode
