Posted to microsoft.public.excel.programming

choice[_2_] choice[_2_] is offline

external usenet poster

Posts: 84

backwards sum

i have a list of numbers in column A, and a value in B1.
is there a way to find if/what numbers in column A can add up to the value
in B1?

example Column A: 3,67,235,843,784,23,457647,1,4,235
B1: 305 (which would be 3+67+235)

hope that makes sense.
thanks in advance

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Excel is Backwards!	Randy Rich	Setting up and Configuration of Excel	9	February 15th 07 05:25 PM
Excel is Backwards!	Randy Rich	Excel Discussion (Misc queries)	8	February 14th 07 06:18 PM
Vlookup backwards	GarToms	Excel Discussion (Misc queries)	2	January 30th 06 08:26 PM
Can you work this backwards	Box666	Excel Discussion (Misc queries)	1	November 22nd 05 05:37 PM
Tab backwards	Garry Jones	Excel Programming	3	November 5th 03 11:41 AM

All times are GMT +1. The time now is 10:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us