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 |
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 |
Counting more than one criteria
For 4 Male In:
=SUMPRODUCT(--(B1:B100=4),--(C1:C100="Male"),--(D1:D100="IN")) -- Gary''s Student - gsnu200770 |
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 |
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 |
All times are GMT +1. The time now is 10:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com