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...
Can't say I understood what you'd like to calculate, better if you illustrated that by manually added desired result - for people who has no idea about exam scores, total percent's, etc.
As a comment:
- data validation list better to generate on the same data you use for weights. Typing list manually is the cause of possible errors.
- to take weight for some answer
=INDEX('Sections '!$B$4:$B$8, MATCH(E15,'Sections '!$A$4:$A$8,0))to calculate the sum of weights for the section
=SUMPRODUCT(COUNTIF(E15:E18,'Sections '!$A$4:$A$8)*'Sections '!$B$4:$B$8)
Above formulas are for this section