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.
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?