Office Software Thread, Excel - Counting Grades (alphabetic)? in Technical; Hi - does anyone have any experience with using Excel to count letters in excel?
Eg I have an excel ...
20th August 2009, 10:50 AM #1
Excel - Counting Grades (alphabetic)?
Hi - does anyone have any experience with using Excel to count letters in excel?
Eg I have an excel file with many grades in it, the grades are letters rather than numbers, so A, B, C, etc.
We are looking for a way to count the number of A's, B's, C's etc across the whole spreadheet.
I am weak at excel and can do basic number forumas but am stumbed by counting Text.
IDG Tech News
20th August 2009, 10:55 AM #2
Hope this helps
20th August 2009, 11:14 AM #3
If you just want a raw count then countif is good; if you want a bit more structure (how many of each grade in each subject then dcounta is the function to use.
I've attached a sample. Key thing is that you have headings for each of your subjects and then this section becomes a table you're going to analyse.
The analysis section has a set of criteria (name above grade) and then you use the dcounta function to say
look at table XXX (make sure you use absolute referencing - highlight the data and press F4)
the column number doesn't matter for what we're doing here (can't remember what it does!)
the final bit says "count when English=A" (or Maths=B etc)
It looks hard but you actually only type in the first formula; you then just drag right to do all the English and then copy/paste for the other subjects.
Excel is fab :-)
Thanks to srochford from:
20th August 2009, 11:20 AM #4
Thanks Excel gurus!!!! The countif works an absolout treat!
Beer at the next educonference for you two!
By TechR in forum General Chat
Last Post: 18th December 2008, 11:58 AM
By danIT in forum MIS Systems
Last Post: 3rd November 2008, 04:51 PM
By contink in forum General Chat
Last Post: 9th August 2008, 12:21 PM
By NickHoughton in forum Classified Adverts
Last Post: 22nd June 2008, 03:59 PM
By _Bat_ in forum MIS Systems
Last Post: 2nd November 2006, 11:25 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)