help with summation please!!!!

[mfield]

I have a list of over 1000 different numbers, both positive and negative. I am looking for the combination of probably 10-20 of these numbers that equal -$26763.59. Is there some function or way that Excel can pull only those numbers out of the 1000 that summed together equal the -$26763.59? Thanks in advance

 

[north19701]

I'm not sure how much this will help, but a similar issue was given as a Challenge of the Month.

http://www.mrexcel.com/pc09.shtml

 

[Zack Barresse]

you could always custom autofilter for less than -$26763.59.

then there is conditional formatting, but i'm unclear as to what your final result should be.

 

[Seti]

Here is one of many threads on this topic.

 

[mfield]

I'm not quite an excel pro....the challenge that you replied to me with looks like a very similar problem. How do I use the macro given as the answer to the August challenge for my problem? Thanks