Deb,

I will send you a workbook that has a macro that can do that.

Send me an email - take the space out and change the dot to a .

HTH,
Bernie
MS Excel MVP

"Deb" wrote in message
...
I have a column of numbers that I need to find only a
subset that adds up to a specific value. Is there a
formula to do this? Ex: A1 through A1 thru A24 equals
3899 but I need to find only 5 fields that add up to 640.