software

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 = lt;70.
Any suggestions? I am sure it can be done...

You can use this method and adapt it to your grades

www.contextures.com/xlFunctions02.html#Range

--
Regards,

Peo Sjoblom

(No private emails please)quot;Gatesterquot; gt; wrote in message
...
gt; I'm a teacher, and I'd like Excel to total how many students in each class
gt; get A's through F's. A = 90-100, B = 80-89, C = 75-79, C = 70-74, F =
gt; lt;70.
gt; Any suggestions? I am sure it can be done...If you have a column of numeric grades (100,95,...) say in column A, then
enter in B1:

=IF(A1gt;89,quot;Aquot;,IF(A1gt;79,quot;Bquot;,IF(A1gt;74,quot;Cquot;,IF(A1gt;70,quot; Dquot;,quot;Fquot;))))
and copy down. This will convert the grades to letters. Elsewhere enter:

=COUNTIF(B:B,quot;Aquot;)
=COUNTIF(B:B,quot;Bquot;)
=COUNTIF(B:B,quot;Cquot;)
=COUNTIF(B:B,quot;Dquot;)
=COUNTIF(B:B,quot;Fquot;)
to get the count of As,Ab,Cs,Ds, and Fs
--
Gary''s Studentquot;Gatesterquot; wrote:

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

Gary's Student -

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

:-)

Gatester

quot;Gary''s Studentquot; wrote:

gt; If you have a column of numeric grades (100,95,...) say in column A, then
gt; enter in B1:
gt;
gt; =IF(A1gt;89,quot;Aquot;,IF(A1gt;79,quot;Bquot;,IF(A1gt;74,quot;Cquot;,IF(A1gt;70,quot; Dquot;,quot;Fquot;))))
gt; and copy down. This will convert the grades to letters. Elsewhere enter:
gt;
gt; =COUNTIF(B:B,quot;Aquot;)
gt; =COUNTIF(B:B,quot;Bquot;)
gt; =COUNTIF(B:B,quot;Cquot;)
gt; =COUNTIF(B:B,quot;Dquot;)
gt; =COUNTIF(B:B,quot;Fquot;)
gt; to get the count of As,Ab,Cs,Ds, and Fs
gt; --
gt; Gary''s Student
gt;
gt;
gt; quot;Gatesterquot; wrote:
gt;
gt; gt; I'm a teacher, and I'd like Excel to total how many students in each class
gt; gt; get A's through F's. A = 90-100, B = 80-89, C = 75-79, C = 70-74, F = lt;70.
gt; gt; Any suggestions? I am sure it can be done...

You are very welcome.
--
Gary's Studentquot;Gatesterquot; wrote:

gt; Gary's Student -
gt;
gt; Thank you very much for taking the time to reply. It was exactly what I
gt; needed, and easily implemented.
gt;
gt; :-)
gt;
gt; Gatester
gt;
gt; quot;Gary''s Studentquot; wrote:
gt;
gt; gt; If you have a column of numeric grades (100,95,...) say in column A, then
gt; gt; enter in B1:
gt; gt;
gt; gt; =IF(A1gt;89,quot;Aquot;,IF(A1gt;79,quot;Bquot;,IF(A1gt;74,quot;Cquot;,IF(A1gt;70,quot; Dquot;,quot;Fquot;))))
gt; gt; and copy down. This will convert the grades to letters. Elsewhere enter:
gt; gt;
gt; gt; =COUNTIF(B:B,quot;Aquot;)
gt; gt; =COUNTIF(B:B,quot;Bquot;)
gt; gt; =COUNTIF(B:B,quot;Cquot;)
gt; gt; =COUNTIF(B:B,quot;Dquot;)
gt; gt; =COUNTIF(B:B,quot;Fquot;)
gt; gt; to get the count of As,Ab,Cs,Ds, and Fs
gt; gt; --
gt; gt; Gary''s Student
gt; gt;
gt; gt;
gt; gt; quot;Gatesterquot; wrote:
gt; gt;
gt; gt; gt; I'm a teacher, and I'd like Excel to total how many students in each class
gt; gt; gt; get A's through F's. A = 90-100, B = 80-89, C = 75-79, C = 70-74, F = lt;70.
gt; gt; gt; Any suggestions? I am sure it can be done...