Hi all,

I will need to sum a daily routine for users to input their commitment on the type of exercises they had.

Each row (per day) with multiple columns (type of exercises) should have predefined values from (0, 10,20,....,100) where all these will be added per row with the columns and should not exceed 100. Anything less or greater than 100 will have a pop out window to prompt for error.Count_input_perRow_equalto100.jpgTest.xlsx

Basically, i will the follow logic flow:-

1) user to input the range of predefined number via a drop down menu
2) user select a pre-defined value range from rows of 8 to 12
3) user defined value in each horizontal row will be automatically computed
if defined result is less or greater than 100, an error box will be shown

Please advice how i can achieve this.

Thnak you very much.