How do I count cells with different criteria in excel?

**Richie17** · January 5th 07, 04:49 PM posted to microsoft.public.excel.worksheet.functions

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?

**Dave F** · January 5th 07, 04:51 PM posted to microsoft.public.excel.worksheet.functions

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?

**Richie17** · January 5th 07, 04:59 PM posted to microsoft.public.excel.worksheet.functions

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?

**Teethless mama** · January 5th 07, 05:01 PM posted to microsoft.public.excel.worksheet.functions

=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?

**Richie17** · January 5th 07, 05:09 PM posted to microsoft.public.excel.worksheet.functions

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?

**Bernard Liengme** · January 5th 07, 06:16 PM posted to microsoft.public.excel.worksheet.functions

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I count nonblank text cells in Excel	gerns	Excel Discussion (Misc queries)	3	November 7th 08 03:46 PM
Count Cells that meet Criteria	kmason	Excel Worksheet Functions	6	August 24th 06 04:31 PM
count criteria within a set range in excel	Allan from Melbourne	Excel Discussion (Misc queries)	3	August 1st 06 03:11 PM
How to count the number of Excel cells with text formatted Italic	phausman	Excel Worksheet Functions	3	July 19th 06 04:32 PM
Cells User Select Locked after upgrade to Excel 2002	TWilson	Excel Discussion (Misc queries)	1	August 5th 05 12:22 PM