I'd assume that when you adjust the numbers you are probably adding or
subtracting 1 from one of the numbers in the list. If that is the
case, why not put a formula in the last cell that calculates the
adjusted number. If the percentages are in cells A1 through A50 you
could change A50 to =1-sum(A1:A49) to force them to add.

- John