One way:

Assuming headings in row 1 and data starting in row 2:

D2: =IF(B2<"",B2,"")
D3: =IF(B3<"",D2+B3,"")

Copy D3 down as far as required.


In article ,
Debbie wrote:

Hi


What formula do I need to use to create a running balance in my budget
spreadsheet i.e. I have 4 columns A = Name, B = Period Actual spend, C =
Period budget spend, D = Year to date actual spend. So I want to be able to
enter a value into B at the end of every month and D will automatically
change.

P.s. I'm a novice so I hope I explained myself ok?