Any question answered...

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

•

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.

•

CYOA in reply to @gbj_tester

Obviously due to thickery I'm getting a formula parse error on your version when I paste the function from post #81953 into cell C6.

This is how my table looks:

About

Avatar for gbj_tester @gbj_tester started