View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cairan O'Toole Cairan O'Toole is offline
external usenet poster
 
Posts: 1
Default How to count number of occurences of two different things at once?

Does anyone know how I would count the number of times two things happen? For
instance there are the following columns

Column A: FirstName
Column B: LastName
Column C: Quadrant
Column D: Group

There are four different quadrants (i.e. 1,2,3,4) and three different groups
(Adult, youth, child).
How do I calculate how many Adults are in quadrant 1, how many in quadrant
2, how many in quadrant 3, etc. and the same for the youth and child groups?
I have tried many many times...
Please help,
Cairan