Previous by Date | Next by Date | Date Index
Previous by Thread | Next by Thread
| Thread Index
| LM_NET
Archive
| |
Whoops - I copied the wrong formula - but by doing a search for Counting Text in the Help of Excel - you can find the much simpler formula to count single text. Sorry for the confusion...chalk it up to a strange weekend and a very busy morning.... Toni Koontz Librarian St. Charles Preparatory School Columbus, Ohio akoontz@cdeducation.org Carpe Diem ----- Original Message ----- From: "Toni Koontz" <akoontz@cdeducation.org> To: <LM_NET@LISTSERV.SYR.EDU>; "James Lerman" <lermanj@GMAIL.COM> Sent: Tuesday, September 02, 2008 9:00 AM Subject: Re: Help with Excel >I found this by going to the Help in Excel and searching for " counting > text" > > It looks fairly simple and if you try it in a test Excel worksheet you can > probably do OK. > The formatting may not cary over into this email - so you might want to > just > go to Eaxcel Help and look at that. > > ...Count how often multiple text or number values occur by using functions > Use the IF and SUM functions to do this task: > > a.. Assign a value of 1 to each true condition by using the IF function. > b.. Add the total, by using the SUM function. > Example > The example may be easier to understand if you copy it to a blank > worksheet. > > How to copy an example > > 1.. Create a blank workbook or worksheet. > 2.. Select the example in the Help topic. > Note Do not select the row or column headers. > > > > Selecting an example from Help > > 3.. Press CTRL+C. > 4.. In the worksheet, select cell A1, and press CTRL+V. > 5.. To switch between viewing the results and viewing the formulas that > return the results, press CTRL+` (grave accent), or on the Tools menu, > point > to Formula Auditing, and then click Formula Auditing Mode. > > 1 > 2 > 3 > 4 > 5 > 6 > 7 > A B > Salesperson Invoice > Buchanan 15,000 > Buchanan 9,000 > Suyama 8,000 > Suyama 20,000 > Buchanan 5,000 > Dodsworth 22,500 > Formula Description (Result) > =SUM(IF((A2:A7="Buchanan")+(A2:A7="Dodsworth"),1,0)) Number of > invoices for Buchanan or Dodsworth (4) > =SUM(IF((B2:B7<9000)+(B2:B7>19000),1,0)) Number of invoices > with > values less than 9000 or greater than 19000 (4) > =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0))) Number of > invoices > for Buchanan with a value less than 9,000. (1) > > > Note The formulas in this example must be entered as array formulas > (array > formula: A formula that performs multiple calculations on one or more sets > of values, and then returns either a single result or multiple results. > Array formulas are enclosed between braces { } and are entered by pressing > CTRL+SHIFT+ENTER.). Select each cell that contains a formula, press F2, > and > then press CTRL+SHIFT+ENTER. > > > Toni Koontz > Librarian > St. Charles Preparatory School > Columbus, Ohio > akoontz@cdeducation.org > Carpe Diem > ----- Original Message ----- > From: "James Lerman" <lermanj@GMAIL.COM> > To: <LM_NET@LISTSERV.SYR.EDU> > Sent: Monday, September 01, 2008 8:26 PM > Subject: Help with Excel > > >> 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/ >> -------------------------------------------------------------------- >> > -------------------------------------------------------------------- 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/ --------------------------------------------------------------------