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