# how to create a running balance?

#### Elliott

##### Board Regular
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

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

#### JohnnyTightlips

##### Board Regular
In cell b2: =b1+a2

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

#### pedro-egoli

##### Well-known Member
To avoid Balances appearing all the way down after dragging try this small addition

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

Pedro

#### Elliott

##### Board Regular
how would I create an average balance, as:

A B
3 3
5 4
8 4

much appreciated,

Elliott

#### JohnnyTightlips

##### Board Regular

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

##### Well-known Member
I don't know how you got that last 4 in column B. Is this what you're looking for?
Book1
ABCD
133
254
385.333333
424.5
524
Sheet1

#### jmckeone

##### Well-known Member
Book2
ABCD
1AB
22=AVERAGE(A\$2:A2)
34=AVERAGE(A\$2:A3)
49=AVERAGE(A\$2:A4)
512=AVERAGE(A\$2:A5)
Sheet1

#### Elliott

##### Board Regular
worked great, many thanks!

Replies
1
Views
49
Replies
0
Views
75
Replies
27
Views
807
Replies
7
Views
144
Replies
3
Views
118