Can Excel count the number of scores within a range?
 

I'm a teacher, and I'd like Excel to total how many students in each class
get A's through F's. A = 90-100, B = 80-89, C = 75-79, C = 70-74, F = <70.
Any suggestions? I am sure it can be done...

Can Excel count the number of scores within a range?
 

You can use this method and adapt it to your grades

http://www.contextures.com/xlFunctions02.html#Range

--
Regards,

Peo Sjoblom

(No private emails please)


"Gatester" wrote in message
...
I'm a teacher, and I'd like Excel to total how many students in each class
get A's through F's. A = 90-100, B = 80-89, C = 75-79, C = 70-74, F =
<70.
Any suggestions? I am sure it can be done...

Can Excel count the number of scores within a range?
 

If you have a column of numeric grades (100,95,...) say in column A, then
enter in B1:

=IF(A189,"A",IF(A179,"B",IF(A174,"C",IF(A170," D","F"))))
and copy down. This will convert the grades to letters. Elsewhere enter:

=COUNTIF(B:B,"A")
=COUNTIF(B:B,"B")
=COUNTIF(B:B,"C")
=COUNTIF(B:B,"D")
=COUNTIF(B:B,"F")
to get the count of As,Ab,Cs,Ds, and Fs
--
Gary''s Student


"Gatester" wrote:

I'm a teacher, and I'd like Excel to total how many students in each class
get A's through F's. A = 90-100, B = 80-89, C = 75-79, C = 70-74, F = <70.
Any suggestions? I am sure it can be done...

Can Excel count the number of scores within a range?
 

Gary's Student -

Thank you very much for taking the time to reply. It was exactly what I
needed, and easily implemented.

:-)

Gatester

"Gary''s Student" wrote:

If you have a column of numeric grades (100,95,...) say in column A, then
enter in B1:

=IF(A189,"A",IF(A179,"B",IF(A174,"C",IF(A170," D","F"))))
and copy down. This will convert the grades to letters. Elsewhere enter:

=COUNTIF(B:B,"A")
=COUNTIF(B:B,"B")
=COUNTIF(B:B,"C")
=COUNTIF(B:B,"D")
=COUNTIF(B:B,"F")
to get the count of As,Ab,Cs,Ds, and Fs
--
Gary''s Student


"Gatester" wrote:

I'm a teacher, and I'd like Excel to total how many students in each class
get A's through F's. A = 90-100, B = 80-89, C = 75-79, C = 70-74, F = <70.
Any suggestions? I am sure it can be done...

Can Excel count the number of scores within a range?
 

You are very welcome.
--
Gary's Student


"Gatester" wrote:

Gary's Student -

Thank you very much for taking the time to reply. It was exactly what I
needed, and easily implemented.

:-)

Gatester

"Gary''s Student" wrote:

If you have a column of numeric grades (100,95,...) say in column A, then
enter in B1:

=IF(A189,"A",IF(A179,"B",IF(A174,"C",IF(A170," D","F"))))
and copy down. This will convert the grades to letters. Elsewhere enter:

=COUNTIF(B:B,"A")
=COUNTIF(B:B,"B")
=COUNTIF(B:B,"C")
=COUNTIF(B:B,"D")
=COUNTIF(B:B,"F")
to get the count of As,Ab,Cs,Ds, and Fs
--
Gary''s Student


"Gatester" wrote:

I'm a teacher, and I'd like Excel to total how many students in each class
get A's through F's. A = 90-100, B = 80-89, C = 75-79, C = 70-74, F = <70.
Any suggestions? I am sure it can be done...