View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default numbers sum to a specific amount

Hi

Have a look he
http://tinyurl.com/r8xkv

Hope this helps.
Andy.

"Bentley26" wrote in message
...
For example: I have about 10 different dollar amounts and I want to see
if
there is any combination of those numbers that total to a specific dollar
amount.

For example if i had the following numbers in colum A; $1.20, $3.25,
$5.90,
$6.00, $0.46, ect.. and I wanted excel to tell me if there is any
combination
of numbers that add up to exactly $6.46. Is that possible?