General discussion

Locked

Add As I Go

By Murray_G ·
Usin EXCEL for WIN 98 I want to keep a running total of the figures I put in a column. EX: In col A1 I insert 5 in A2 6, in cell b2 I want the result 11. Then in cell a3 I put in 4, b3 should = 15, in a4 I put 5, b4 should be 20. How can I copy the formula =SUM(a1+a2) so that it adds a3 a4 a5.....a256 as I enter figures?

This conversation is currently closed to new comments.

20 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Add As I Go

by Jerry 27 In reply to Add As I Go

=SUM(B2:B256)
Hope this helps
Good Luck

Collapse -

Add As I Go

by Murray_G In reply to Add As I Go

That will give me a total in cell B256. What about a running total from B2........B255?

Collapse -

Add As I Go

by SyscoKid In reply to Add As I Go

Just copy it. Excel uses relative references unless you specify otherwise.

If you put =SUM(a1+a2) in cell b2, then copy it to cell b4, you will find that the formula has changed to =SUM(a3+a4).

Excel assumes that since you copied the formula 2 cells to the right, it should increment each of the cell references in the formula by two.

So you can copy that single formula of
=SUM(a1+a2) to every cell across row b and have it work correctly.

If you wanted the formula to ALWAYS refer to a1+b1 no matter where you copied it, the formula would be =SUM($a$1+$a$2). This is called absolute reference.

Collapse -

Add As I Go

by SyscoKid In reply to Add As I Go

Next time I promise to read the question fully before answering it. I gave a heck of an answer, it's just not to the question you were asking. Sorry for wasting your time!

Collapse -

Add As I Go

by SyscoKid In reply to Add As I Go

Thinking about it some more.

If in b3 you put=SUM(a3,b2) you would add what's in a3 to the result of the previous formula.

Then just copy the formula in b3 down the rest of the column.

Collapse -

Add As I Go

by SyscoKid In reply to Add As I Go

Did you try my second suggestion?

1
5 =SUM(a1+a2)
4 =SUM(a3,b2}
5 =SUM(a4,b3)
3 =SUM(a5,b4)
etc.

Collapse -

Add As I Go

by SyscoKid In reply to Add As I Go

Er, That's supposed to represent columns 1 and 2 but it didn't format right.

Collapse -

Add As I Go

by Murray_G In reply to Add As I Go

The question was auto-closed by TechRepublic

Collapse -

Add As I Go

by DKlippert In reply to Add As I Go

This assumes that A1 contains a field name like Sales.

Go to Insert>Name Define.
In the Names in workbook box type MyRange
At the bottom in the Refers to box type:

=OFFSET(Sheet1$A2,0,0,COUNT(Sheet1$A:$A)+1)

This creates a dynamic range. You can now enter a formula somewhere else, even on another worksheet, such as =Sum(MyRange)
The range will continue to expand or contract as items are entered or deleted.

Collapse -

Add As I Go

by Murray_G In reply to Add As I Go

Poster rated this answer

Back to Desktop Forum
20 total posts (Page 1 of 2)   01 | 02   Next

Related Discussions

Related Forums