Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old 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
Default 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   Report Post  
Old 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
Default 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   Report Post  
Old 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
Default 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   Report Post  
Old 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
Default 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   Report Post  
Old 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
Default 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   Report Post  
Old 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
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 04: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


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

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017