I have a spreadsheet for showing where the money goes. The left hand columns have the date, redit card outgoings and current account outgoings.
I then have several columns for categories like food, clothing, hobbies etc
Is there any way to have the sum of each column updated automaticaly at the bottom of the spreadsheet (say on row 500? At the moment I manually insert the autosum, then select the figures in each column, and repeat this nthe next month.
Many thanks, both. I have never used formulas before. So it isn't possible to use just one 'formula' etc to put the totals of the respective columns all along the bottom, just the individual formulae? [Yes, I am very lazy <grin>].
Click in A500, hover the cursor over the bottom right of the cell until the cursor turns into a + then hold down the left mouse button and drag right to copy the formula to as many columns as needed then release the mouse button. Excel will automatically adjust the dragged formulas to refer to the correct column.