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

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?