[ms office - 2003] Excel - Counting Grades (alphabetic)?

[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

[tmcd35]

=COUNTIF(A1:Z200,"A")
=COUNTIF(A1:Z200,"B")
...
...

 

Hope this helps

[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 :-)

grades.xls

[Butuz]

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

 

Beer at the next educonference for you two!

 

Cheers

 

Butuz