The title might be confusing, but here’s what I want to do:
Let’s say I have 4 columns, each has 100 elements. Each column has a sum of a range of its values, so let’s say the first 50 values.
I want to be able to change the range of the first column and all the other summations will also get updated with the same first range change. So if the first changes to sum up to the first 70 values, all other summations also show the first 70 of their respective columns. The range can increase or decrease.