Forum Discussion
Solved
Help on a Excel Formula
So I have this formula to help calculate grades: =IF(K3="A", 93.33,IF(K3="B",83.33, IF(K3="C",73.33,IF(K3="D",63.33))))+IF(K3="A-", 90,IF(K3="B-",80, IF(K3="C-",70,IF(K3="D-",60))))+IF(K3="A+", 100,...
Okay so I misunderstood what you are trying to accomplish. If you want to total the corresponding scores of the grades in columns C thru K you should use SUMPRODUCT and the same table of grades/scores that I gave above. I used 'grades' and 'score' as named ranges.
The formula for the total in L13 is =SUMPRODUCT(SUMIF(grades,C13:K13,score))
(the next row is a vlookup under each column, then a sum in L14, which I used to check my work ☺)
Try using a VLOOKUP instead of all that typing...
Make sure to use the dollar signs around the range. Then copy to appropriate columns.
Okay so I misunderstood what you are trying to accomplish. If you want to total the corresponding scores of the grades in columns C thru K you should use SUMPRODUCT and the same table of grades/scores that I gave above. I used 'grades' and 'score' as named ranges.
The formula for the total in L13 is =SUMPRODUCT(SUMIF(grades,C13:K13,score))
(the next row is a vlookup under each column, then a sum in L14, which I used to check my work ☺)
Thank you
You're welcome!
