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)