Article View: comp.sys.mac.apps
Article #10095Excel counting letter grades???
From: Kevin Fairchild
Date: Mon, 16 Nov 1992 02:27
Date: Mon, 16 Nov 1992 02:27
15 lines
1270 bytes
1270 bytes
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 two complicated ways to do this: 1) use the Crosstab plug-in (complicated, confusing, and slooooooow), or 2) use DCOUNT on a database *but* you can only do that for one grade at a time. I can't believe that there isn't a simple function like HOWMANY(range,what_to_look_for). What am I missing? Kevin Fairchild Soon-to-be-late-of-UCSD *** I certainly hope that my opinions are not those of UCSD.***
Technical Details
Message-ID:
<41030@sdcc12.ucsd.edu>Path:
arc1-ca.pugleaf.net!sparky!uunet!news.centerline.com!noc.near.net!news.Brown.EDU!qt.cs.utexas.edu!cs.utexas.edu!zaphod.mps.ohio-state.edu!magnus.acs.ohio-state.edu!usenet.ins.cwru.edu!agate!dog.ee.lbl.gov!network.ucsd.edu!sdcc12!helix!fairchilShow Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!news.centerline.com!noc.near.net!news.Brown.EDU!qt.cs.utexas.edu!cs.utexas.edu!zaphod.mps.ohio-state.edu!magnus.acs.ohio-state.edu!usenet.ins.cwru.edu!agate!dog.ee.lbl.gov!network.ucsd.edu!sdcc12!helix!fairchil From: fairchil@helix.ucsd.edu (Kevin Fairchild) Newsgroups: comp.sys.mac.apps Subject: Excel counting letter grades??? Message-ID: <41030@sdcc12.ucsd.edu> Date: 16 Nov 92 02:27:13 GMT Sender: news@sdcc12.ucsd.edu Organization: University of California, San Diego Lines: 16 Nntp-Posting-Host: helix.ucsd.edu