| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Occurence of Criteria in Multiple Lists of Data
I was wondering if there was a way to count the amount of times that
something occurs based on two sets of data. Take for example a list of people's favorite fruits and sports: Fruit Sports Apple Hockey Orange Soccer Banana Football Apple Hockey Apple Soccer Orange Hockey How could I count the number of times that a person both liked Apples and Hockey? Please let me know if you need a further explanation of what I am looking for. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for counting the occurence of more than one condition | Excel Worksheet Functions | |||
| Multiple Criteria pulled from Drop Down Lists | Excel Discussion (Misc queries) | |||
| counting with multiple criteria | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Threaded Mode
