Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct question | Excel Discussion (Misc queries) | |||
Sumproduct question | Excel Discussion (Misc queries) | |||
SUMPRODUCT Question | Excel Discussion (Misc queries) | |||
Question about sumproduct | Excel Discussion (Misc queries) | |||
Question about sumproduct | Excel Discussion (Misc queries) |