+ Post New Thread
Results 1 to 4 of 4
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 ...
  1. #1
    Butuz's Avatar
    Join Date
    Feb 2007
    Location
    Wales, UK
    Posts
    1,579
    Thank Post
    211
    Thanked 220 Times in 176 Posts
    Rep Power
    63

    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.

    Cheers

    Butuz

  2. #2

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,614
    Thank Post
    845
    Thanked 880 Times in 730 Posts
    Blog Entries
    9
    Rep Power
    326
    Code:
    =COUNTIF(A1:Z200,"A")
    =COUNTIF(A1:Z200,"B")
    ...
    ...
    Hope this helps

  3. Thanks to tmcd35 from:

    Butuz (20th August 2009)

  4. #3

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,154
    Thank Post
    114
    Thanked 527 Times in 450 Posts
    Blog Entries
    2
    Rep Power
    123
    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 :-)
    Attached Files Attached Files

  5. Thanks to srochford from:

    Butuz (20th August 2009)

  6. #4
    Butuz's Avatar
    Join Date
    Feb 2007
    Location
    Wales, UK
    Posts
    1,579
    Thank Post
    211
    Thanked 220 Times in 176 Posts
    Rep Power
    63
    Thanks Excel gurus!!!! The countif works an absolout treat!

    Beer at the next educonference for you two!

    Cheers

    Butuz

SHARE:
+ Post New Thread

Similar Threads

  1. Tesco Voucher Counting
    By TechR in forum General Chat
    Replies: 18
    Last Post: 18th December 2008, 10:58 AM
  2. SIMS Target Grades
    By danIT in forum MIS Systems
    Replies: 2
    Last Post: 3rd November 2008, 03:51 PM
  3. 6 days and counting
    By contink in forum General Chat
    Replies: 15
    Last Post: 9th August 2008, 11:21 AM
  4. Counting Crows, Liverpool, July 8th - 2 tickets available
    By NickHoughton in forum Classified Adverts
    Replies: 2
    Last Post: 22nd June 2008, 02:59 PM
  5. CMIS - Cannot edit target grades?
    By _Bat_ in forum MIS Systems
    Replies: 4
    Last Post: 2nd November 2006, 10:25 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •