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

--

HTH

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


"BYBaby" wrote in message
...
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
--
Yvonne Mays