excel formula and functions

Copper Contributor

I have numbers in a column, with a sum total C11: C51 = 1, If I take the number is cell C16, I want the sum total to remain 1. so how can I do that.

1 Reply

thanks