Forum Discussion

Copper Contributor

Feb 22, 2019

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,...

excel

Formulas and Functions

andyritzert
Feb 22, 2019
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 ☺)

andyritzert

Brass Contributor

Feb 22, 2019

Try using a VLOOKUP instead of all that typing...

Make sure to use the dollar signs around the range. Then copy to appropriate columns.

andyritzert

Brass Contributor

Feb 22, 2019

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 ☺)

dancled
Copper Contributor
Feb 22, 2019
Thank you
- andyritzert
  Brass Contributor
  Feb 22, 2019
  You're welcome!