Desktop

General discussion

Locked

By ·
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 +

Collapse -

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

Collapse -

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

Collapse -

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 -

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 -

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 -

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 -

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

Collapse -

The question was auto-closed by TechRepublic

Collapse -

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 -

20 total posts (Page 1 of 2)   01 | 02   Next

Related Discussions

• 0

Is Freesync Gaming Monitor Technology works with nVidia

michaeljohnson4595 //

• 2

Looking To Buy HP Color LaserJet 1500 2500 Cyan Printer Toner Ink

vintagelooks86 //

• 2

rhodyste2 //

• 4

How do you think of the lastest all in one computer?

1330711002 //

• 2

Need help to remove/detach stand of LG monitor (22M45D)

lanceramin //