| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count if all both apply
I have a column (E) that contains names of districts, and column a column (H)
that contains names of teachers and I need to summarize how many times a certain teacher is connected to a district. Both columns have multiple entries in both columns. What equation would I use to find out how many times teacher S is listed with an entry of district C (in other words, if the district was Camas, how many times would teacher S show up connected to that district). Clear as mud, I'm sure District Teacher Camas S Camas D Camas P Camas S Riddle S Riddle P Camas S My result should be 3 thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Won't apply to all worksheets | Setting up and Configuration of Excel | |||
| apply changes to all sheets | Excel Worksheet Functions | |||
| How to apply a weighting | Excel Discussion (Misc queries) | |||
| How can I apply this calculation | Excel Discussion (Misc queries) | |||
| Apply to next X cells to the right... | Excel Worksheet Functions | |||
Threaded Mode
