Running balance

Copper Contributor

Hi - I need help with an excel formula to show a remaining balance.  For example, I have an account with an available balance.  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).  I've tried looking online but can't seem to find any formulas that work for my situation.

4 Replies

@cdean001 , what about

=SUM(anothersheet!<balance>, C10:N10)

Hi @Sergei Baklan, I tried that formula but it is increasing my remaining balance rather than subtracting the invoice amounts from it.  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.  Does that make sense?

@cdean001 , when it could be

=anothersheet!<balance> -SUM($C$10:N10)

You may start from

=anothersheet!<balance> -SUM($C$10:C$10)

and drag it to the right to show result for each month. 

 

 

 

 

WOO HOO!! That worked! Thank you so much @Sergei Baklan! Total life saver!