[LM_NET] Help with Excel

[James Lerman <lermanj@GMAIL.COM>]

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
-- 
James Lerman
Coordinator
New Jersey Consortium for Middle Schools
447 Hennings Hall
Kean University
Union, NJ 07083
Tel 908-737-3761
Fax 908-737-3760
jlerman@kean.edu
http://tinyurl.com/l5xst - Educational Hotlinks for Middle School People
http://tinyurl.com/zp4ee - Educational Hotlinks for New Teachers

--------------------------------------------------------------------
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/
--------------------------------------------------------------------