Count age and gender records from two different columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Can't use two independent criteria with COUNTIF().

Try

=SUMPRODUCT(--(A1:A1000=<certain age>),--(B1:B1000=<certain gender>))
 
=SUMPRODUCT(--(A2:A100=age),--(B2:B100="gender"))

--

HTH

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count pieces of records meet conditions in different columns 1
COUNTIF function 3
code to copy range 1
Conditional Formula, counting one criteria in a range based on ano 3
Calculating Average Length of Service 2
If, then 1
Woman age 40 9
OptionButton with Bookmark text output 1

Back
Top