Forum Discussion
Weighted scores based on text answers formula
Hi Everyone! I have a site inspection template, whereby there are 44 questions. This is a typical scenario the same as when you take an exam, where the overall score is given based on answers. How...
It's not clear to me what you want, exactly, but hopefully this will get you on your way.
Enter the following formula in G1:
=IFERROR(VLOOKUP(E1,'Sections '!$A$4:$B$8,2,FALSE),"")
Fill down to G143 (or perhaps G162).
In (for example) G164, enter the formula
=SUM(G1:G162)
This is the total score.
If you need more help, please provide a more detailed explanation of what you want.