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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting more than one criteria
Try this:
=SUMPRODUCT(--(B1:B100=4),--(C1:C100="Male"),--(D1:D100="IN")) HTH, Paul -- "Justin Chips" <Justin wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting more than one criteria
For 4 Male In:
=SUMPRODUCT(--(B1:B100=4),--(C1:C100="Male"),--(D1:D100="IN")) -- Gary''s Student - gsnu200770 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting more than one criteria
Thanks very much... I have been fighting with this formula
=SUMPRODUCT(B3:B13=4,C3:C13="Male",D3:D13="IN") and getting frustrated. Why do simple things like brackets and dashes make such a difference!!! Thanks again, Justin "PCLIVE" wrote: Try this: =SUMPRODUCT(--(B1:B100=4),--(C1:C100="Male"),--(D1:D100="IN")) HTH, Paul -- "Justin Chips" <Justin wrote in message ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting more than one criteria
Thanks very much... I have been fighting with this formula
=SUMPRODUCT(B3:B13=4,C3:C13="Male",D3:D13="IN") and getting frustrated. Why do simple things like brackets and dashes make such a difference!!! Thanks again, Justin "Gary''s Student" wrote: For 4 Male In: =SUMPRODUCT(--(B1:B100=4),--(C1:C100="Male"),--(D1:D100="IN")) -- Gary''s Student - gsnu200770 |
Reply |
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 |