[mso] Re: Excel something like countif

Okay, Linda, I'm almost there (maybe).  Read your tutorial, and fooled  
around with it, but control shift enter isn't putting the braces there,  
and I'm not sure about what I have on the inside anyway.  here's the  
formula as it stands:
=((countif (O2:O107, "x")*(C2:C107, "b"))
Column O is the particular day I'm working on, column C is the column with  
b for boy and g for girl.  X means they were there that day.

I tried it without the outside (), and I tried it with two countif rather  
than the mulitiplication, but the mulitiplication is how it is on your  
tutorial.  I'm confused because your formula for count all the people who  
make less than $1000 in a given department uses sum.

I feel like I'm really really close and once I have that a-ha moment I  
will love this, but help me get there.

On Fri, 22 Jul 2005 12:14:55 -0400, Linda F. Johnson  
<linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

> Use an array formula for this.
>
> Here's my mini tutorial on array formulas...it should show you how to do
> this easily:
> http://personal-computer-tutor.com/arrayformulas.htm
>
>
> Linda
> Linda's Computer Stop
> http://personal-computer-tutor.com
> ABC Free Ezine ~ Free Ebooks and Tutorials
> *all outgoing mail scanned by Norton AV.  If you got a bug that looks  
> like
> it came from me, it did NOT!
>
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On  
> Behalf
> Of Kathie Felts
> Sent: Friday, July 22, 2005 11:44 AM
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Excel something like countif
>
> I know there's a way to do this, I just don't remember it, and I don't
> remember enough to ask the help file a smart question.
>
> Here's what I need to do.  I have a spreadsheet in which I am keeping
> attendance at our Boys & Girls Club.  I have a sneaking suspicion that
> while our attendence is going up, we are losing our boys.  So, right now,
> I use countif to tell me the total of kids on a day (there is a column  
> for
> a day and there are x's if they are there--Rows are kids' names).  Below
> that count, though, I want to know how many boys and how many girls.  So,
> if a row has an x on it, instead of counting just then, I want it to go
> look at say, column D and count if column d (the column for boy/girl) has
> a "b" in it AND column AW (the column for the given day) has an "x".  I'm
> imagining two rows underneath the total of the days--one row for boys and
> one row for girls.
>
> Thanks in advance,
> Kathie
>
>
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx  
> or MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, send an email to
> mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the  
> quotes) in the subject line.
>
> Or, visit the group's homepage and use the dropdown menu.  This will  
> also allow you to change your email settings to digest or vacation (no  
> mail).
> http://www.freelists.org/webpage/mso
>
> To be able to use the files section for sharing files with the group,  
> send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an  
> invitation with instructions.  Once you are a member of the files group,  
> you can go here to upload/download files:
> http://www.smartgroups.com/vault/msofiles
> *************************************************************
>
>



-- 
Kathie Felts
Blooming Prairie, MN

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: