SUMPRODUCT question
Thanks Per, just the job.
--
Traa Dy Liooar
Jock
"Per Jessen" wrote:
Hi
=SUMPRODUCT((G4:G40018)*1,(G4:G400<=34)*1,(F4:F40 0="M")*1)
Regards,
Per
"Jock" skrev i meddelelsen
...
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:G40018)*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
--
Traa Dy Liooar
Jock
|