Apr 11 2019 10:37 AM
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.
Apr 11 2019 11:30 AM
@cdean001 , what about
=SUM(anothersheet!<balance>, C10:N10)
Apr 11 2019 02:55 PM
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?
Apr 12 2019 07:42 AM
@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.
Apr 15 2019 11:02 AM