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

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

Try

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

In article ,
BYBaby wrote:

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

=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