You are reading a single comment by @CYOA and its replies. Click here to read the full conversation.
  • 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

    • google sheets screen.png
  • 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.

About

Avatar for CYOA @CYOA started