Hello,

Would like your input to know what is the best formula that I can apply for the following scenario that would provide total rating out of 100.

There are 5 sections in document totalling 100 but only 4 sections are being completed as section 2 is not to be accounted.

Section 1 (Rating 1 to 10)
8
9
Total 17

Section 2 (Rating 1 to 10)
n/a
n/a
Total: N/A

Section 3 (Rating 1 to 10)
10
8
Total 18

Section 4 (Rating 1 to 10)
8
8
Total 16

Section 5 (Rating 1 to 10)
8
8
Total 16

What is the best best formula to display Total rating (out of 100) where section 2 is not to be accounted= ?

Thanks for your suggestions.