# Excel - Counting Grades (alphabetic)?

• 20th August 2009, 09:50 AM
Butuz
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
• 20th August 2009, 09:55 AM
tmcd35
Code:

```=COUNTIF(A1:Z200,"A") =COUNTIF(A1:Z200,"B") ... ...```
Hope this helps ;)
• 20th August 2009, 10:14 AM
srochford
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 :-)
• 20th August 2009, 10:20 AM
Butuz
Thanks Excel gurus!!!! The countif works an absolout treat!

Beer at the next educonference for you two!

Cheers

Butuz