How do I sum questions to not pass a certain value?

Support
1

I want to be able to sum my choices to 100 and I would like to know the formula, if there is any

2

Hello Erblina,

I had attached the excel for your reference, hope it works for you.

total_constraint.xlsx (10.3 KB)

4

Thank you so much, however i need the sum without having the separate variable to write the total in it

5

You can use the constraint in the sum for not exceeding the value of 100.

Dummy excel is attached in here

total_constraint.xlsx (10.3 KB)