Rows Totals, Sums.

Originally Posted by Soplinx

Hi there, here's my problem:


I have 3 columns, first one contains my initial value, say 20. Second column contains a number X, which can be replaced by anything, say 5 for example. Third column is my total, 25. Simple: =B2+C2

Now I want to modify second column's value by 7, and see 32 in third column. As in 25(first total)+7=32. I can't seem to be able to do this.

If possible, I'd like to use only 3 colums, or 4. I know I can add a new column for every X but I would eventually end up with 150 columns, which is what I'm trying to avoid.

Thanks a lot for your help!

Soplinx

Confusing question, I recently answered one for a 'plus' and 'minus' cell which might be the answer you need, but if not, then

in B1 to B9 put your numbers

in B10 put =Sum(B1:B9)

in C10 put =Sum(C1:C9)

in D10 put =B10+C10

any changes you make to B1:B9 or C1:C9 will affect the total

Was that what you wanted?

if not look at http://www.excelforum.com/showthread.php?t=579522

---

Originally Posted by Soplinx

Both of your answers actually answer my question :P Thanks a lot. I am more interested in the second one, the coded sheet one. Though, I really can't figure out how it works. Do I have to paste the code, then manually enter =SUM(B2:C2) in D2?

Here's what I want to end up with, maybe I wasn't quite accurate the first time heh...

Column A:
Name
Pedro
BoB
Danny
Math

Column B:
Initial Number
0
0
0
0

Column C:
Number X
5
5
5
5

Column D:
Total ----> SUM I guess
5
5
5
5

Then, once I have 5 in D, I want to change C value to 3 and end up with :

Column D:
Total
8
8
8
8


I pasted your code but then again, I didn't really understand what I was doing so I can't go any further.

Thanks a lot for your help though, both of your answers seem to be accurate, I just can't figure them out in my case...

Excel doesn't easily do what you are asking, it prefers a solid audit trail such that you need to assign a column for each number you will use.

Then in D2 you can put =B2+C2 as you knew.

The option around this is to put in D2

=B2+C2+Sum(AA2:FT2)

This gives you your 150 columns, but from AA onwards, and you can hide enough columns (say L to Z) and then hide all used columns AA onwards so that the next column for use is on the right of the visible screen.

You can 'formula fill' D2 downwards as required.
----

The other two options I can think of are Circular references and VB Code, these would provide what you need, but have a price in nuisance value and required learning.

---

Does this help you?

---