ExcelBanter - Count age and gender records from two different columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Count age and gender records from two different columns (https://www.excelbanter.com/excel-worksheet-functions/38856-count-age-gender-records-two-different-columns.html)

BYBaby

Count age and gender records from 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
--
Yvonne Mays

JE McGimpsey

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

Bob Phillips

=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

All times are GMT +1. The time now is 03:01 PM.