Posted to microsoft.public.excel.misc

DJuan

external usenet poster

Posts: 2

Formula Help Required

Can anyone tell me if there is a way Excel can do the following?

I need to work out which amounts are added together to make up a total amount.
eg

If I have a list of numbers i.e
1200
1000
2000
3000
1100
900
3120

And I have a total of 4100 is there a formula that can work out how many
combinations (from the list of numbers) can add up to this total?? ie
1. 1200+900+2000
or 3000+1100

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Reusing formula	Tony29	Excel Discussion (Misc queries)	7	September 7th 06 03:34 AM
Help required for formula	recklaw	Excel Discussion (Misc queries)	2	March 15th 06 11:11 AM
Match then lookup	Tenacity	Excel Worksheet Functions	9	December 3rd 05 05:30 AM
addition to my date formula...required	Juco	Excel Worksheet Functions	5	January 30th 05 11:48 AM
Rate of return required formula	Alorasdad	Excel Worksheet Functions	1	November 18th 04 03:14 AM

All times are GMT +1. The time now is 04:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us