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

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

Hello Erblina,

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

total_constraint.xlsx (10.3 KB)

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

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)