Posted to microsoft.public.excel.programming

Realwoodies Realwoodies is offline

external usenet poster

Posts: 1

Finding a sum

I am trying to find a way to start with a number and get a group of numbers from a list that sum to the number. For example, if I have the # 30, and I have a list {2,5,10,20}, I know that the numbers from the list that sum to 30 are 10 & 20. Is there a function in Excel that will do this for me?

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
Finding a Value	SueK	Excel Discussion (Misc queries)	3	September 21st 08 07:27 PM
Finding the top 10	Bertha needs help[_2_]	Excel Discussion (Misc queries)	13	August 5th 08 04:41 PM
Finding Value	Darryl	Excel Worksheet Functions	1	April 13th 05 07:42 PM
Finding max value	paradise	Excel Programming	2	November 7th 03 01:42 AM
vba..finding first non-zero value in a row	Andrew Appel	Excel Programming	3	October 20th 03 05:33 AM

All times are GMT +1. The time now is 03:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us