| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting rows that contain any one item listed in another row
Hi, I have the following table:
Area Person Members X Jack Jack Y Mary Peter Z Jack X Peter X Mary Z Mary I want to count the number of Persons who are Members and have entries in Area X. So in the example above it should return 2 (Jack and Peter have X entries and are Members but Mary is not a member though she has X entry). How to do this in Excel? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting cells with text not listed. | Excel Worksheet Functions | |||
| How to select a listed item? | Excel Worksheet Functions | |||
| How to select a listed item? | Excel Discussion (Misc queries) | |||
| Counting transactions as listed in reports | Excel Discussion (Misc queries) | |||
| Delete rows listed less than 8 times??? | Excel Worksheet Functions | |||
Threaded Mode
