[mso] Re: Excel something like countif

Yes...you use sum, NOT count....that's the way array formulas work...read my
tutorial again and see the way to get a sum and how it looks compared to the
way to get a count.  See this part:
______________________
Now, what if we wanted a count instead of a sum? That's easy to fix. All you
need to do is replace the part of the formula that multiplies the cells by
themselves, with a one (1).

Just adjust the above formula to look like this, then hit ctrl+shift+enter
again to update it:

=SUM((A2:A11>500)*1)+SUM((A2:A11<300)*1)
___________________


I have NO idea why ctrl+shift+enter is not working for you.  Are you sure
you are doing it correctly? 


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 12:33 PM
To: mso@xxxxxxxxxxxxx
Subject: [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.



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