Posted to microsoft.public.excel.misc

DB74

external usenet poster

Posts: 20

Addition function of multiple cells

Does anyone know if there is a function that will take a list of numbers in
different cells and run various addition combinations on the list to detemine
which cells will add to a specific number? For example:

A1 = 1
A2 = 2
A3 = 5
A4 = 7

I want to know which cells added to gether will give me 6...answer = A1 + A3

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
Addition of 2 cells is not correct	MAX	Excel Worksheet Functions	3	February 18th 09 12:44 PM
Simple Addition Function	sneal	Excel Worksheet Functions	3	September 11th 08 07:36 PM
sum addition function	mryan	Excel Worksheet Functions	4	February 24th 08 06:51 PM
Multiple Configurations Addition for Sum	rooferboyFinancial	Excel Worksheet Functions	0	November 8th 06 02:49 PM
Spacing in cells is preventing addition	kris	Excel Worksheet Functions	4	September 9th 06 06:40 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us