excel formula

Occasional Visitor

i want to create a formula for my house hold budget. i want it to work in these columns

income      outgoings       balance


income  =A1+A3 being the balance

outgoings  =A2-A3 being balance

i want to be able to put in my income on a weekly basis

then i want to put in my outgoings on a weekly basis

i want to have a rolling balance as the money goes in and comes out 

i just cant get my head around setting it up

any help would be great thank you


1 Reply


You may use formula as here


but better to transform your data in structured table as on the right, with that it will be expanded automatically. Formula is


where CellUp is the named reference as