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

is it you look for?

=if(A1="U","Failed","Passing")


"DOUG ECKERT" wrote:

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" wrote:

is it you look for?

=if(A1="U","Failed","Passing")


"DOUG ECKERT" wrote:

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

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

"DOUG ECKERT" wrote:

'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" wrote:

is it you look for?

=if(A1="U","Failed","Passing")


"DOUG ECKERT" wrote:

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

On Sep 15, 3:15*pm, DOUG ECKERT
wrote:
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



"DOUG ECKERT" wrote:
'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" wrote:

is it you look for?

=if(A1="U","Failed","Passing")

"DOUG ECKERT" wrote:

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- Hide quoted text -

- Show quoted text -


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