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

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

For 4 Male In:

=SUMPRODUCT(--(B1:B100=4),--(C1:C100="Male"),--(D1:D100="IN"))

--
Gary''s Student - gsnu200770

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

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