SUMPRODUCT question

[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

 

[Per Jessen]

Hi

=SUMPRODUCT((G4:G400>18)*1,(G4:G400<=34)*1,(F4:F400="M")*1)

Regards,
Per

 

[Jock]

Thanks Per, just the job.
--
Traa Dy Liooar

Jock

Hi

=SUMPRODUCT((G4:G400>18)*1,(G4:G400<=34)*1,(F4:F400="M")*1)

Regards,
Per

 

[Per Jessen]

Hi Jock

Thanks for your reply.

Glad to help

Regards,
Per

Thanks Per, just the job.