SUMPRODUCT question

J

Jock

I want to count seperately the number of women and men within age groups from
the given data.

I can find out how many combined entries are in each age group with this:
SUMPRODUCT((G4:G400>18)*1,(G4:G400<=34)*1)
other age groups are 35-39, 40-44, 45-49 and so on up to 70+
If column F has M or F to identify gender, how can I use that to seperate
the male entries from female entries for each group?


I wish to create a small table detailing
 

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

Top