Dear Excel(lent) users,

I want to add up percentages:

I have 4 columns (A, B, C, D). In
A: Name of a person (selectable from validation list)
B: Percentage
C: Name of a person (selectable from validation list, same list as A)
D: Percentage

You can select a person and add a percentage. This means that one person can
be selected multiple times.

I know want to control, that one person is not going to exceed 100%. Is
there some formula for this?

Thanks for helping me out !

Kind regards,

Jay