Formula Problem
Assuming letter grades are in D1:M1 and lookup table is A1:A6
In D2 enter =VLOOKUP(D1,$A$1:$A$6,2,FALSE)
Drag across to M2
In N2 enter =SUM(D2:M2) returns 42 as you state in your description.
But that does sum up the total for "each" grade.
Gord Dibben Excel MVP
On Thu, 1 Dec 2005 15:41:02 -0800, nospaminlich
wrote:
I've got a range of grades in cols D:M e.g B,C,A,D,F,B,C,A,A,E
and a lookup table named "Points"
A 6
B 5
C 4
D 3
E 2
F 1
In Col N I'm trying to create a formula which adds the points for each grade
in Cols D:M
Using the example above the answer would be 42 but I'm stuck on how to
create a formula to calculate it.
Any help would be much appreciated
Thanks a lot
|