COUNTING GRADES

[hebburnsent]

I have a list of student grades in a column - eg. A, B, C, D E etc. I need a formla to count the number of A's, B's etc. which is updated if the grades changed.

Thank you

 

[Brian from Maui]

I have a list of student grades in a column - eg. A, B, C, D E etc. I need a formla to count the number of A's, B's etc. which is updated if the grades changed.

Thank you

=COUNTIF(A1:A10,"A")

 

[Yogi Anand]

I have a list of student grades in a column - eg. A, B, C, D E etc. I need a formla to count the number of A's, B's etc. which is updated if the grades changed.

Thank you

Hi hebburnsent:

Welcome to the Board!

y031129h1.xls
	A	B	C	D
1	Grades		Grade	CountOfGrades
2	B		A	3
3	B		B	6
4	B		C	1
5	C		D	1
6	D
7	A
8	A
9	A
10	B
11	B
12	B
Sheet6

I hope this helps.

 

[Nimrod]

if the grades are in columnA the following code . Place in anther column, would count all the "A"s in Column A.
=COUNTIF(A:A,"A")

Method 2.
Use "Data....Subtotals" ... "Count"

Method 3.
Make a Pivot table

Good Luck :wink:

 

[hebburnsent]

WOW

I am just starting to try and get to grips with excel.

Thanks a million! Worked no problem!