Running Total on Excel?

Question

I need to keep a running total of info on an excel spread sheet and are unsure how to do this. The excel help does not help very much. Could someone tell me how to do this.

Answer 1

I assume that you want a running total alongside your data (i.e. incrementing down a column next to your amount column)
so assuming your amounts are in Column A and that Row 1 contains Headings (A1='Amount',B1='Running Total')
You would type in cell B2: "=A2" to start off your Running Total
While in cell B3 type: "=A3+B2"
Then just copy the formula in B3 down the whole column and you will get your running total. Moreover this running total will be dynamic in that if any amount value changes anywhere in the sheet the running total column would refresh itself accordingly.

Answer 2

I could help you but I would need to see it to be of any use. I will try my best off of the description you presented. Column C = Deposits Column D = Withdrawals Column E = current balance And E53 = true balance Alright if I am correct here, Column C and D will be simple input numbers. It may be useful to format these cells as currency. Column E would be =(Previous current balance) +(deposit amount in that row) - (withdrawal amount in that row) You would make one for your first equation for column E and then simply copy and paste it into the rest of column E. Excel would automatically change the equation for each cell.

Answer 3

use formula where you want total to appear . . .

=sum(. . . )

In the parentheses, use cell locations or range

For example:

=sum(A1+A2) Cell locations
=sum(A1:A41) Cell range

Hope this helps.

Answer 4

Check this link

http://support.microsoft.com/?kbid=213445