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