Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

conditional summation

Status
Not open for further replies.
dmpritch82

dmpritch82

Aerospace
Joined
Aug 26, 2005
Messages
9
Location
US
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
 
Sort by date Sort by votes
Is this the "spacer" problem....which spacers will give me a certain length??

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
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top