Previous by Date | Next by Date | Date Index
Previous by Thread | Next by Thread
| Thread Index
| LM_NET
Archive
| |
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/ --------------------------------------------------------------------