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/
--------------------------------------------------------------------
LM_NET
Mailing List Home