Re: [LM_NET] Help with Excel

[Buzzy Nielsen <buzzy.nielsen@GMAIL.COM>]

Hi Jim,

I'm pretty sure that the function you need is "COUNTIF."  It basically 
counts things in a range of cells if a cell contains certain data 
specified by you.  Here's the syntax:

=COUNTIF(A2:A14,"yes")

Where the A2:A14 part is the range of cells in which you want to count 
the yeses and noes.  The quotations do need to be there, as they tell 
Excel that you're dealing with text.  Capitalization shouldn't matter, 
though.

I hope that helps!

Cheers!
Buzzy Nielsen

**************************
Assistant Director
North Bend Public Library
1800 Sherman Ave.
North Bend, OR  97459
541-756-0400
http://info.cclsd.org/non


James Lerman wrote:
> Hi Everyone,
> I'm hoping someone can help me with a rather basic Excel question.
> I have a list of responses in a long spreadsheet that contains a lot of
> other data. However, I want to make a count of how frequently "yes" and "no"
> are given as responses in one column of the sheet. These words are the only
> data in the particular column. What formula should I use to make this
> frequency count and what is the syntax in which I should write the formula?
> I understand I will have to write a formula in one cell for "yes" responses
> and another formula in another cell for "no" responses.
> Thanks to anyone who can help.
> Sincerely,
> Jim Lerman
>   

--------------------------------------------------------------------
Please note: All LM_NET postings are protected by copyright law.
  You can prevent most e-mail filters from deleting LM_NET postings
  by adding LM_NET@LISTSERV.SYR.EDU to your e-mail address book.
To change your LM_NET status, e-mail to: listserv@listserv.syr.edu
In the message write EITHER: 1) SIGNOFF LM_NET  2) SET LM_NET NOMAIL
 3) SET LM_NET MAIL  4) SET LM_NET DIGEST  * Allow for confirmation.
 * LM_NET Help & Information: http://www.eduref.org/lm_net/
 * LM_NET Archive: http://www.eduref.org/lm_net/archive/
 * EL-Announce with LM_NET Select: http://lm-net.info/
 * LM_NET Supporters: http://www.eduref.org/lm_net/ven.html
 * LM_NET Wiki: http://lmnet.wikispaces.com/
--------------------------------------------------------------------