How do I create a running balance?

  • Thread starter Thread starter Kate
  • Start date Start date
K

Kate

I am finding it extremely diffucult to have a running balance, G column is
the running total, anything in E column is to be subtracted from G column and
anything in F column is to be added to the G column total.
So G-E+F=G
Does this make sense and how in blazers do you write the formula so it does?
I am tearin my hair out!!!!
Thanks
 
I assume your running total is running down the column (G). So, you need to
start with the previous value of G (from the row above), subtract E, and add
F to get the new total. In G6 (for example), your formula might be:

=G5-E6+F6

You can copy this formula down column G to keep a running total.

Hope this helps,

Hutch
 
Back
Top