Any question answered...

You are reading a single comment by @CYOA and its replies. Click here to read the full conversation.

•

gbj_tester in reply to @CYOA
You total weights are 56, so the maximum score is 560. Just multiply the score by the weight for each cell, sum the products and divide by 5.6 to get a percentage. In the cell representing the eventual percentage for row 6, you want
```
=((8*D6)+(9*E6)+(9*F6)+(10*G6)+(5*H6)+(5*I6)+(5*J6)+(5*K6))/(56/10)
```
I've got a similar sheet which weights various columns differently, and I put the weights in a row above the data so that I can adjust them easily, if you do that you need to change the weighting numbers to absolute references to the cells containing the weights, and you need to change "56" to a reference to the cell containing the sum of the weights

•

CYOA in reply to @gbj_tester
Thank you for this - trying to get my head around it.

I found something similar online which had the function:
```
=if(sum(D6:K6), SUMPRODUCT(D6:K6,D6:K6,$D$5:$K$5)/(10*sumproduct($D$5:$K$5,$D$5:$K$5)),"")
```

•

gbj_tester in reply to @CYOA

I found something similar online which had the function:

That's just a tarty version, having the weighting factors in row 5 and returning an empty string if you haven't entered values in the row 6 scoring cells.

About

Avatar for CYOA @CYOA started