Forum Discussion
Running Totals
I have two issues I'm trying to sort out.
We are a non-profit organization required to keep track of grant monies.
I have a spreadsheet that is keeping good track of expenditures, however...
I need to create two columns that keeps a running total of total monies spent and balance remaining.
In addition to that, I have two columns that keep track of mileage
I also need to keep track of the accumulated mileage expense that I can easily restart upon payments made.
I know these should be simple formulas, however as yet I've had to continually recreate the wheel in my spreadsheets.
If anyone could please help, I will appreciate it.
4 Replies
For t ravel expenses, I would want to keep a running total as mileage accumulated, but easily reset when a payment for mileage is made.
I would want to keep a running total of what amount has been spent, along with what amount is remaining.
I'm trying to figure out how to attach a document, I may have to attach a screenshot.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
