Running balance

Question

Hi - I need help with an excel formula to show a remaining balance.&nbsp; For example, I have an account with an available balance.&nbsp; I need to set up a formula (in say, column O) that will reference the beginning total (found on another sheet) and then provide a continuously calculated remaining balance once I enter invoices for each month (say columns C thru N).&nbsp; I've tried looking online but can't seem to find any formulas that work for my situation.

sergeibaklan · Answer

cdean001&nbsp;, what about
=SUM(anothersheet!&lt;balance&gt;, C10:N10)

cdean001 · Answer

Hi SergeiBaklan,&nbsp;I tried that formula but it is increasing my remaining balance rather than subtracting the invoice amounts from it.&nbsp; I apologize if my previous question wasn't clear enough, I need each invoice entry to subtract from the initial amount leaving me with a remaining balance.&nbsp; Does that make sense?

sergeibaklan · Answer

cdean001&nbsp;, when it could be
=anothersheet!&lt;balance&gt; -SUM($C$10:N10)
You may start from
=anothersheet!&lt;balance&gt; -SUM($C$10:C$10)
and drag it to the right to show result for each month.&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;

cdean001 · Answer

WOO HOO!! That worked! Thank you so much SergeiBaklan! Total life saver!

Forum Discussion

Running balance

4 Replies

Resources