formula
 

I have a large spreadsheet of dollar amounts. Is there a formula to
pick out the individual amounts that add up to a certain total?

formula
 

No it isn't, you can use solver


http://tinyurl.com/mz7bq


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com




wrote in message
oups.com...
I have a large spreadsheet of dollar amounts. Is there a formula to
pick out the individual amounts that add up to a certain total?