🚀 go-pugleaf

In article <41030@sdcc12.ucsd.edu> fairchil@helix.ucsd.edu (Kevin Fairchild) writes:
>
>From fairchil Sun Nov 15 18:26:39 1992
>To: /home/helix/fairchil/.article
>
>What am I missing?  I'm using Excel 4.0 to keep track of my students' grades. 
>I have a column of letter grades.  What I want to do is create a simple
>distribution; that is, tell me how many A's, how many B's, etc.  I have found

Excel is bad at this (wingz has a freq distribution command), but anyway, one
learns to live with this stuff!  If you're familiar with using arrays, the
following array command (you have to use apple-enter to enter this into a
cell) assumes that i have a list of "records" (rows 2 through 158);  in
column B there is a character {a,b,c,d,e}.  I want to count the number of
each of them at the bottom.  At the bottom (starting at row 168), there are 5
summary rows, with the character "a..e" in column b.  In whatever column the
following formula appears will be the frequency count.

{=SUM(IF($B$2:$B$158=$B162,1,0))}

Note that the braces {} are applied by Excel; don't enter them into the
formula.  Also, you can substitue lots of things for the "1", like:

{=SUM(IF(LEFT($B$2:$B$158,1)=$B162,E$2:E$158,0))}

this formula sums column E for all rows that contain the single letter in
the summary rows column B in the first position of the string in column B.

Anyway, if this is confusing read the section about arrays in the Excel
manual.  You won't know any more about arrays, but *this* posting will look
trivial!

masson
masson@solbourne.com