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.
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:
1 Attachment
Obviously due to thickery
Mine, not yours, in all probability. I use OpenOffice, not Excel or Google, so your syntax might be different from mine.
@CYOA started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
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.