J
jstrelec
I have a total value in one cell. I have another set of values in
several columns (same row) that I want to sum a certain number of those
values left to right to arrive at the number closest to the total value
in the first cell that I mentioned.
For example if my total value is 100 and I have values in cells left to
right of 40, 30, 20, 15, 40 - I want Excel to only sum values 40
through 15 to arrive at the value closest to 100.
Any ideas?
several columns (same row) that I want to sum a certain number of those
values left to right to arrive at the number closest to the total value
in the first cell that I mentioned.
For example if my total value is 100 and I have values in cells left to
right of 40, 30, 20, 15, 40 - I want Excel to only sum values 40
through 15 to arrive at the value closest to 100.
Any ideas?