how to create a running balance?

[Elliott]

Hi,

This is probably really simple, but how do I create a running balance? For example, if I have a column A of numbers rounded to the second decimal place, and I want to create column B that represents a running balance as:

A B
3 3
5 8
10.68 18.68
-5 13.68

Many thanks,

Elliott

 

[JohnnyTightlips]

In cell b2: =b1+a2

Drag that formula down, making sure the cell references are relative (no $ signs)

 

[pedro-egoli]

To avoid Balances appearing all the way down after dragging try this small addition

=IF(ISBLANK(A2),"",B1+A2)

Pedro

 

[Elliott]

how would I create an average balance, as:

A B
3 3
5 4
8 4


much appreciated,

Elliott

 

[JohnnyTightlips]

I'm not 100% on what you're trying to average, Is it the average of the previous running average (B2) and the new number (A3)?

In that case it would be =average(A3,B2). You can also add in Pedro's ISBLANK suggestion

Otherwise, to get the average for coluimn A: In cell B1:

=average($A$1:A1)

and drag down

 

[Barry Katcher]

I don't know how you got that last 4 in column B. Is this what you're looking for?

Book1
	A	B	C	D
1	3	3
2	5	4
3	8	5.333333
4	2	4.5
5	2	4
Sheet1

 

[jmckeone]

Book2
	A	B	C	D
1	A	B
2	2	=AVERAGE(A$2:A2)
3	4	=AVERAGE(A$2:A3)
4	9	=AVERAGE(A$2:A4)
5	12	=AVERAGE(A$2:A5)
Sheet1

 

[Elliott]

worked great, many thanks!