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
|