Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count cells with different criteria in excel?
I have a column with M or F (Male/Female) and I also have a column that has
their age. How do I count how many 6 year olds there are AND how many of those are either male or female? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count cells with different criteria in excel?
You would need to use SUMPRODUCT.
Something like =SUMPRODUCT(--(A1:A100="M"),--(B1:B10=6)) Dave -- Brevity is the soul of wit. "Richie17" wrote: I have a column with M or F (Male/Female) and I also have a column that has their age. How do I count how many 6 year olds there are AND how many of those are either male or female? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count cells with different criteria in excel?
Dave you are my new hero!...but now that you helped me with that does that
mean I have to get back to some real work? :( My co-workers and myself appreciate what this can do for us now. Thanks, Richie17 "Dave F" wrote: You would need to use SUMPRODUCT. Something like =SUMPRODUCT(--(A1:A100="M"),--(B1:B10=6)) Dave -- Brevity is the soul of wit. "Richie17" wrote: I have a column with M or F (Male/Female) and I also have a column that has their age. How do I count how many 6 year olds there are AND how many of those are either male or female? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count cells with different criteria in excel?
=SUM((A1:A100="M")*(B1:B100=6))
ctrl+shift+enter, not just enter "Richie17" wrote: I have a column with M or F (Male/Female) and I also have a column that has their age. How do I count how many 6 year olds there are AND how many of those are either male or female? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count cells with different criteria in excel?
Thanks Teethless Mama!
Your suggestion also works. I'm not sure why but hey why complain! Thanks, Richie17 "Teethless mama" wrote: =SUM((A1:A100="M")*(B1:B100=6)) ctrl+shift+enter, not just enter "Richie17" wrote: I have a column with M or F (Male/Female) and I also have a column that has their age. How do I count how many 6 year olds there are AND how many of those are either male or female? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count cells with different criteria in excel?
Read here from details
http://www.xldynamic.com/source/xld.SUMPRODUCT.html http://mcgimpsey.com/excel/formulae/doubleneg.html best wishes (do I get a Hero medal?) -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Richie17" wrote in message ... Dave you are my new hero!...but now that you helped me with that does that mean I have to get back to some real work? :( My co-workers and myself appreciate what this can do for us now. Thanks, Richie17 "Dave F" wrote: You would need to use SUMPRODUCT. Something like =SUMPRODUCT(--(A1:A100="M"),--(B1:B10=6)) Dave -- Brevity is the soul of wit. "Richie17" wrote: I have a column with M or F (Male/Female) and I also have a column that has their age. How do I count how many 6 year olds there are AND how many of those are either male or female? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I count nonblank text cells in Excel | Excel Discussion (Misc queries) | |||
Count Cells that meet Criteria | Excel Worksheet Functions | |||
count criteria within a set range in excel | Excel Discussion (Misc queries) | |||
How to count the number of Excel cells with text formatted Italic | Excel Worksheet Functions | |||
Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) |