Hi - I am trying to create a formula where a range of cells will always sum up to the value of another cell.

For example
A1:H1 = I1
Where I1 is a value
and A1:H1 is the projection to equal the value.

A1 B1 C1 D1 E1 F1
40 40 40 40 40 200

I would like it where, once a cell is filled in with an actual number, the rest of the cells will recalculate to total I1.

A1 B1 C1 D1 E1 F1
60 35 35 35 35 200

Is there anyway to do this? My calculation previously turned out to be a circular reference, so it wouldn't work.

Thank you!