View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hockey14 hockey14 is offline
external usenet poster
 
Posts: 2
Default 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.