Forum Discussion
Running balance
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 b...
cdean001 , what about
=SUM(anothersheet!<balance>, C10:N10)
Hi SergeiBaklan, 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?