what you could do, though not ideal, is add a column at the side of each column you are totalling. In A1, some text, eg:- "Total of this Column." In B1 the formula =SUM(a:a). Everytime you add something to an 'a' cell b1 will give you a running total of all 'a' cells. Likewise for the rest of your columns.
I'm not sure if this is exactly what you want but give it a try and see.
Say you have 100 rows in the A column with data. Put =SUM(A1:A104) in cell A105, so you have the sum you want in cell A105 and 4 unoccupied cells above. The column then grows by adding data to cell A101, A102, etc, but each time you occupy a free cell, you insert a new row.
But you want to have the total at the top, so you need to insert a row above A1 and in the new now unoccupied cell A1 you need to put =A? where A? is the current location of the sum you created initially.
I've got a few set up like this and they work fine.
Am I right in assuming you're entering new data manually? If not, you'd need to associate each entry with an input date then you could easily truncate it at the end of the year. But it's messy and cumbersome.
If you're creating something that's continuous over a number of years, you could create individual yearly worksheets within a workbook. It's not too difficult to then link data between worksheets if you need to.
qwbos: This is my first year of living on a "fixed" income and, while estimates of expenditure are all very well and good, an accurate picture of my annual spending patterns will help guide me in the future.
At the present, I do not expect to run beyond a single year's expenditure figures as it really is something of a waste of time. However I shall review the situation in December 2020 and if the year's spending is within a gnats-whisker of my estimate (budget), I shall not bother with a repeat performance.
I am most interested in finding out my actual spending down at the Ice Rink, while Curling. I had a mental budget of about £2000.00 per season, which includes "hospitality!" and, so far, that appears to be pretty close to reality.