Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting more than one criteria
I need a count of how many times three columns (Year, Gender and Date) have
the same values. For example Year 4, Male and In or Year 8 Male and In. Name Year Gender 25/02/2008 Miles Anderson 4 Male IN Phoebe Brundle 5 Female IN Alexander Cadier 5 Male OUT Archie Chitty 8 Male IN Rupert Coley 7 Male IN Charlie Davies 8 Male IN Bertie Griffiths 6 Male IN Harry Griffiths 8 Male IN Arabella Harvey 4 Female OUT Hugo Harvey 7 Male IN Harry Herbert 8 Male IN |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting, 2 criteria | Excel Discussion (Misc queries) | |||
counting Criteria | Excel Discussion (Misc queries) | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
2 Criteria Counting | Excel Worksheet Functions |