G Guest Aug 4, 2005 #1 Using a COUNTIF formula, I want to count the number of records based on a certain age and gender which are in two different columns
Using a COUNTIF formula, I want to count the number of records based on a certain age and gender which are in two different columns
J JE McGimpsey Aug 4, 2005 #2 Can't use two independent criteria with COUNTIF(). Try =SUMPRODUCT(--(A1:A1000=<certain age>),--(B1:B1000=<certain gender>))
Can't use two independent criteria with COUNTIF(). Try =SUMPRODUCT(--(A1:A1000=<certain age>),--(B1:B1000=<certain gender>))
B Bob Phillips Aug 4, 2005 #3 =SUMPRODUCT(--(A2:A100=age),--(B2:B100="gender")) -- HTH RP (remove nothere from the email address if mailing direct)
=SUMPRODUCT(--(A2:A100=age),--(B2:B100="gender")) -- HTH RP (remove nothere from the email address if mailing direct)
