SUMPRODUCT question
 

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

SUMPRODUCT question
 

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

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

SUMPRODUCT question
 

Hi Jock

Thanks for your reply.

Glad to help

Regards,
Per

"Jock" skrev i meddelelsen
...
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