| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of occurences within a time range | Excel Discussion (Misc queries) | |||
| COUNTIF cannot count decimal number occurences | Excel Worksheet Functions | |||
| count number of occurences on a particular date | Excel Worksheet Functions | |||
| How to count number of occurences in an autofilter list | Excel Worksheet Functions | |||
| count number of occurences within a string | Excel Worksheet Functions | |||
Threaded Mode
