numbers sum to a specific amount

[Bentley26]

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?

 

[Guest]

Hi

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

Hope this helps.
Andy.

 

[Dave O]

Please post all the possible numbers, and I'll let you know how many
combinations add to 6.46.

 

[Dominic LeVasseur]

Here is a link to a VBA solution that worked for me:

http://www.microsoft.com/office/com...6edf37-c9ec-4766-8d6f-b91bb43f5398&sloc=en-us

HTH

 

[Bentley26]

THANK YOU!!!!!!!

Here is a link to a VBA solution that worked for me:

http://www.microsoft.com/office/com...6edf37-c9ec-4766-8d6f-b91bb43f5398&sloc=en-us

HTH

 

[Dominic LeVasseur]

Thank Harlan. <g>

You're welcome. Glad it helped. Thanks for the feedback.