Remember Me?

#1
January 5th 07, 05:49 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jan 2007 Posts: 3
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
January 5th 07, 05:51 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 2,574
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
January 5th 07, 05:59 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jan 2007 Posts: 3
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
January 5th 07, 06:01 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Sep 2006 Posts: 3,718
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
January 5th 07, 06:09 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jan 2007 Posts: 3
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
January 5th 07, 07:16 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 4,393
How do I count cells with different criteria in excel?

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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post gerns Excel Discussion (Misc queries) 3 November 7th 08 04:46 PM kmason Excel Worksheet Functions 6 August 24th 06 04:31 PM Allan from Melbourne Excel Discussion (Misc queries) 3 August 1st 06 03:11 PM phausman Excel Worksheet Functions 3 July 19th 06 04:32 PM TWilson Excel Discussion (Misc queries) 1 August 5th 05 12:22 PM

All times are GMT +1. The time now is 09:26 PM.