numbers sum to a specific amount

Giganews Newsgroups
Subject: numbers sum to a specific amount
Posted by:  Bentley26
Date: Thu, 25 May 2006

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?

Replies