Expense sheet formulas usually break for four reasons: the range does not include the new rows, dates or amounts are stored as text, the criteria do not match the spelling in the data, or someone typed over a formula. Fix those four and a monthly total built with SUMIFS stays right as the sheet grows.
This matters for gig workers because rows are added every few days from payout files, cash notes and bank statements pasted in from several places.
Why does the total stop at last month's rows?
A formula such as =SUM(C2:C120) covers only to row 120. When you paste more data below, the total ignores it and nothing warns you. Use a range long enough for the year, for instance $C$2:$C$2000, or turn the data into a table so ranges grow on their own. Avoid whole-column references in big files only if the sheet slows down; otherwise they are safe.
The four breakages and their fixes
| Symptom | Cause | Fix |
|---|---|---|
| Total misses the latest rows | Range ends too early | Extend the range or use a table |
| SUMIFS returns 0 for a month | Dates stored as text | Convert with Data, Text to Columns, or DATEVALUE |
| A category looks empty | Spelling or extra space differs | Use TRIM and agree category names |
| Total is a plain number | A formula was typed over | Restore the formula, protect the column |
How do you write a monthly total that holds up?
Say dates are in A2:A2000, categories in B2:B2000, amounts in C2:C2000, and the month's first date is in E1, for example 1 November 2026. A month's fuel is:
- =SUMIFS($C$2:$C$2000,$B$2:$B$2000,"Fuel",$A$2:$A$2000,">="&$E$1,$A$2:$A$2000,"<"&EDATE($E$1,1))
The sum range comes first, then each range with its condition. The dollar signs stop the ranges shifting when you copy the formula. EDATE gives the first day of the next month, so the condition covers exactly one month. To make the category a cell reference, replace "Fuel" with $G2 and list your categories down column G.
What breaks when you paste from payout files?
- Amounts arrive with a rupee symbol or commas and are read as text, so they are skipped. Select the column and check that totals change when you click it.
- Dates arrive as 11/03/2026 and one source reads it as March and another as November.
- Merchants arrive in capitals in one file and mixed case in another. SUMIFS is not case sensitive, but trailing spaces still matter.
- Blank rows left in the middle of data confuse pivot tables.
A small worked example
Say your November rows are Fuel 1,350, Fuel 1,500, Servicing 2,400 and Phone 499. The Fuel SUMIFS should give 2,850. If it returns 1,350, the second row's date is text. If it returns 0, the category cell has a trailing space. Total across all four should be 1,350 + 1,500 + 2,400 + 499 = 5,749, which is a check you can place beside the table.
When is a sheet no longer the right tool?
When the work is cleaning, not analysing. If you spend more time repairing text dates and merchant names than reading the results, a tracker is easier. SpendixAI generates reports from the transactions themselves, not hand-built formulas, and you can filter, group and download CSV. It reads statements as PDF, CSV or Excel and you review rows before saving. Try it on one month first.
A weekly habit that prevents most breakage
- Paste new data under the last row, never in the middle.
- Check the sum of the amount column against the statement total.
- Look for left-aligned numbers; they are text.
- Keep a Check cell that compares the sum by category to the sum of everything.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

