Can I show text that represents a number
For letter grades in column A:
=(COUNTIF(A:A,"A+")*4.5+COUNTIF(A:A,"A")*4+COUNTIF (A:A,"B+")*3.5+COUNTIF(A:A,"B")*3+COUNTIF(A:A,"C+" )*2.5+COUNTIF(A:A,"C")*2+COUNTIF(A:A,"D+")*1.5+COU NTIF(A:A,"D"))/COUNTA(A:A)
Thus if column A contained:
A
A+
C
C+
the formula returns 3.25
--
Gary''s Student - gsnu200806
"Ron" wrote:
I want to take a table that shows text in a column for several rows, but the
text in each row represents a number that I can average?
Here's the table - If I want the A+ to represent a number when O enter A+,
how do I do that?:
A+ 4.5
A 4
B+ 3.5
B 3
C+ 2.5
C 2
D+ 1.5
D 1
F 0
|