Here's a suggestion if you're playing with Excel totals if you want to try them (as per my previous post):
Sheet1 is called Balance Sheet and P&L Account
Sheet2 is called Expenses
On the right hand side of sheet1 is Sales then further down Expenses. (Left hand side has my Balance Sheet, right hand side has my P&L Account). Under Expenses each of my columns has a total and that is copied on to sheet1 in the appropriate place.
On sheet2 the first few columns are date, reference, supplier, etc. Further to the right there are columns for Insurance, Telephone, Printing, etc. Small Tools is in column Q.
Rows 1 and 2 of all columns are the name (e.g. Date, reference etc then further to the right Insurance, Telephone, etc.) Column Q Row 1 is "Small", Column Q Row 2 is "Tools". Row 3 for all relevant columns has the total of the column.
Additionally, the sheet uses "Freeze Panes" which keeps the top three rows visible at all times no matter how far down you scroll. (This is why I keep the totals at the top.)
On sheet1 under "Expenses" there is a cell for "Small Tools" (currently £12.71).
On sheet2 there is a column for "Small Tools" with two transactions equalling £12.71.
Sheet1 has the following formula: =Expenses!Q3 to the right of the cell that says "Small Tools"
Sheet2 has the following formula in Row 3: =SUM(Q4:Q111). Alternatively you can have =SUM(Q:Q) but this adds a fair amount to the computer memory!
I'm not saying you've got to do what I've done, but once set up (correctly!), the whole spreadsheet takes care of itself for the year.