Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

numbers sum to a specific amount

1 view
Skip to first unread message

Bentley26

unread,
May 25, 2006, 11:50:01 AM5/25/06
to
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?

Andy

unread,
May 25, 2006, 11:57:24 AM5/25/06
to
Hi

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

Hope this helps.
Andy.

"Bentley26" <Bent...@discussions.microsoft.com> wrote in message
news:0BDB75D1-2FA8-4A20...@microsoft.com...

Dave O

unread,
May 25, 2006, 12:14:43 PM5/25/06
to
Please post all the possible numbers, and I'll let you know how many
combinations add to 6.46.

Dominic LeVasseur

unread,
May 25, 2006, 12:17:02 PM5/25/06
to
Here is a link to a VBA solution that worked for me:

http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.misc&mid=e36edf37-c9ec-4766-8d6f-b91bb43f5398&sloc=en-us

HTH

Bentley26

unread,
May 25, 2006, 1:29:02 PM5/25/06
to
THANK YOU!!!!!!!

Dominic LeVasseur

unread,
May 25, 2006, 1:58:02 PM5/25/06
to
Thank Harlan. <g>

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

0 new messages