Finding which numbers contribute to result

[Lizabeta]

I have a list of 17 numbers. The result I need is $79,161.00

Is there a function or a bit of code that will help me figure out which of the 17 numbers add up to excatly $79,161? Not all of them would be used.

Fun with math. heh.

[contaminated]

I don't think that I understood u entirely, but sounds like you gotta use Goal Seek...

[Lizabeta]

Col A
_____
3456
7842
10318
9744
5076

Answer: 23,236
Used the numbers (or cells) 5076, 7842, 10318 from the list in column A.

Only, I truely have 17 numbers.
Our grant only partially funded the items we requested. While we have a preliminary approval for a dollar amount, we don't have any details yet. Our office was excited and was hoping to be able to figure out which items were approved for purchase. It's not super important, but we are all pretty excited and it could be a while before we have any more details.