Count age and gender records from two different columns

B

BYBaby

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

Can't use two independent criteria with COUNTIF().

Try

=SUMPRODUCT(--(A1:A1000=<certain age>),--(B1:B1000=<certain gender>))
 
B

Bob Phillips

=SUMPRODUCT(--(A2:A100=age),--(B2:B100="gender"))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top