Calculate running totals in an Excel sheet 1

[barnard89]

Hi

I have an excel sheet which has monthwise expenses

each month expense is in one separate row.
How do I calculate the running totals of those values
in the adjacent columns

Please suggest

thanks

 

[Bong]

You can do this pretty simply with formulae in Excel. It isn't really necessary to use VBA: =SUM($A$1:A5)

_________________
Bob Rashkin

 

[xlbo]

how / why is this a VBA question ??

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[AnotherHiggins]

This doesn't require VBA.

Say your info is in column A, with the first row being header info. In cell B2, try this
[tab]=Sum($A$2:A2)
Now drag the formula down.

Lookup Absolute Reference in Excel's help file for more info.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[barnard89]

anotherhiggins

thanks a lot for your reply
it works