I have a bunch of A's and B's on a spreadsheet in one row. How to calculate the number of A's using Excel?

Question

I have like a whole list of grades: A's, B's and C's on a spreadsheets. I need to know like how many got A's, how many got B's and how many got C's.

Is there a shortcut to this, or am I going to have to spend my night counting?

Answer 1

Save the excel file as it is.
Use Edit, Select All function or highlight all data in the spreadsheet.
Go to Data, then sort.
Sort the row/column containing the information. This will also move all your other information around, but if you have already "Saved" the file, it will still be there for you.
Once you perform the Sort function, all the "A's", "B's", and so on will be grouped together. Use the Row numbers on the left side of the spreadsheet to calculate the total number of each grade.

Answer 2

You will use the countif function on excel. Click an empty cell and enter the countif function and specifiy the range of cells ex. C12:C54=A

I do not have it down exactly but if you use help on excel and search for countif...it should walk you through....the end result should look something like.
(COUNTIFA11:A52="A")

The blank cell that you have selected will display a count of the numbers.

Answer 3

you can use an if statement:

suppose these grades are from column a to h in row 1. In an empty cell somewhere type the formula:

countif(a1:h1,"A") do the same for B and C

in case you have never used a formula in excel, one thing you have to remember is when you type the formula in the empty cell you must precede it with an equal sign .

Answer 4

You can use the 'countif' function. =COUNTIF(,"=A") should do.