Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count cells that contain "Y" in columnA IF contains"X" in columnB
Excel 2003- I'm trying to compose a function that will return a numeric value
of cells that contain a given value in one column, but only if they also contain a given value in another coulumn. For example, I want to know how many candidates for a job have accepted their offer (contain "Y" in "Offer Accepted?" column) for each manager's area (contain "John Smith" in "Region of Placement" column). The spreadsheet which contains the data I want to count lists all candidates that have been offered positions, for all regions, sorted by Candidate's last name. I want the Summary worksheet (which will contain the formula) to tell me how many accepted for each individual region. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN | Excel Worksheet Functions | |||
Count cells based on date range in another column | New Users to Excel | |||
Count non-colored cells | Excel Discussion (Misc queries) | |||
Count number of shaded cells | Excel Discussion (Misc queries) |