I would like to be able to have it calculate from A3:K3. Right now the formula is extremely long as I have to do this for every column. Is there a way to change this formula so that it could calculate the whole line?
Unless I misunderstand your question, it sounds like your re-typing the formula for each column? If so then just copy the formula from column K back to the A:J columns. The resulting formulas will automatically reference their respective columns, i.e. A3, B3, C3, etc.
You are correct and that is what I have right now, as seen below. I am trying to make it easier so when I add another column the formula would automatically include the next column so that I wouldn't have to keep on pasting a new set of values.
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 ☺)
Best Response confirmed by
dancled (New Contributor)