conditional summation
conditional summation
(OP)
I am trying to get excel to sum only certain numbers in a range (one column) that is equal to or as close as i can get to a specified number. Example (trying to equal 10):
Range:
1
2
3
4
5
So I want excel to output that I need to add 2, 3, and 5 or 1, 2, 3, and 4 within this range to equal 10. Multiple sulutions are fine.
Any help is appreciated.
Thank You
Range:
1
2
3
4
5
So I want excel to output that I need to add 2, 3, and 5 or 1, 2, 3, and 4 within this range to equal 10. Multiple sulutions are fine.
Any help is appreciated.
Thank You





RE: conditional summation
I just put each size in a loop - so in this case you have five For-Next loops
Record each answer and pick the one you want