ASSIGN NUMBER SCORES TO LETTER GRADES

  • Thread starter Thread starter DOUG ECKERT
  • Start date Start date
D

DOUG ECKERT

I want to code scores "E" and "S" as passing and "U" as not passing. Scores
are in a table of months arranged horizontally. Suggestions are welcome.

DOUG
 
'Close. But, I want to tell Excel to evaluate a range of cells using that
formula. When I try, I receive an error. Utimately, I need to average all
of the scores in the range, based on the number value assigned to each
letter. I could assign a number value to "E" (Excellent), "S" (Satisfactory)
and "U" (Unsatisfactory). But, it would be better to just say the "E" and
"S" cells were passing scores and the "U" cells were failing scores. Then, I
could count either the passing or failing scores and obtain a percentage of
passing scores - (the goal of the exercise). But, first I must persuade the
formula to work on a horizontal range of cells.

DOUG
 
Andri: Here is what worked. It is so simple. I spun my wheels for too long
on this one.

=COUNTIF(B6:M6,"<>U")/((ROWS(B6:M6))*COLUMNS(B6:M6))

Thanks.

DOUG
 
Andri:  Here is what worked.  It is so simple.  I spun my wheels for too long
on this one.

=COUNTIF(B6:M6,"<>U")/((ROWS(B6:M6))*COLUMNS(B6:M6))

Thanks.

DOUG





- Show quoted text -
Click to expand...


Can also use somethng like,
=SUM(COUNTIF(B2:M2,{"E","S"}))/COUNTA(B2:M2)
 
Back
Top