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. ## 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. Code:
```=COUNTIF(A1:Z200,"A")
=COUNTIF(A1:Z200,"B")
...
...```
Hope this helps

3. ## Thanks to tmcd35 from:

Butuz (20th August 2009)

4. 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 :-)

5. ## Thanks to srochford from:

Butuz (20th August 2009)

6. Thanks Excel gurus!!!! The countif works an absolout treat!

Beer at the next educonference for you two!

Cheers

Butuz

SHARE: