A Google Sheets expense template usually stops working for one of four reasons: you are editing a view-only copy, dates or amounts are stored as text, a formula range no longer covers your rows, or a script is waiting for permission. Check each in that order. The formulas below are plain Sheets functions and need no add-ons.
Are you editing your own copy?
If the template does not let you type, you may be looking at someone else's file. Make your own copy from the File menu, and work in the copy. If the template has a script or a custom menu, Sheets may ask for permission the first time; read what it asks before approving, and skip any template whose request surprises you.
Why do my totals show zero or the wrong figure?
The most common cause is numbers stored as text. A cell that is left-aligned with a leading apostrophe or a comma in a pasted bank figure may look right and sum to nothing. Test one cell with =ISNUMBER(C2); FALSE means it is text. To convert a cell like 1,250 stored as text, use =VALUE(SUBSTITUTE(C2,",","")), then paste the results as values.
The same applies to dates. =ISNUMBER(A2) should be TRUE for a real date. If it is FALSE, try =DATEVALUE(A2), and if that fails, the text may be in a different order from your sheet's locale, so retype one and compare.
The formulas that matter
- Total for one category in a month: =SUMIFS($C$2:$C$500, $B$2:$B$500, "Food", $A$2:$A$500, ">="&$F$1, $A$2:$A$500, "<="&$F$2), where F1 and F2 are the first and last dates.
- Total of everything: =SUM($C$2:$C$500).
- Count of rows in a category: =COUNTIF($B$2:$B$500, "Food").
- Safe wrapper for a blank result: =IFERROR(your formula, 0).
- A summary by category: =QUERY($A$1:$C$500, "select B, sum(C) where B is not null group by B", 0).
Argument order matters in SUMIFS: the first argument is the range to add, then pairs of range and condition. If you swap them, you get zero.
What do the error codes mean?
| Error | Usual cause | Fix |
|---|---|---|
| #REF! | A column or sheet the formula used was deleted | Rewrite the formula to the new range |
| #VALUE! | Text where a number was expected | Convert with VALUE and check for stray spaces |
| #N/A | A lookup found no match | Check spelling and spare spaces, or wrap with IFERROR |
| #NAME? | Misspelt function name | Retype the function name |
A worked check with made-up numbers
Say Food rows in November are 420, 1,850, 360 and 2,200. By hand: 420 plus 1,850 is 2,270; plus 360 is 2,630; plus 2,200 is 4,830. If your SUMIFS says 2,630, the last row is probably outside the range or its date is text. Fixing the range or date should give ₹4,830.
When a sheet stops being enough
Sheets are fine until the typing becomes the work. If you find yourself copying bank statement lines every month, SpendixAI can take statement uploads as PDF, CSV or Excel and let you review rows before saving, with categories, reports and CSV downloads. Use the sheet while it serves you, and look at the app when the maintenance outweighs the benefit.
One more practical tip: protect the formula cells. Sheets lets you restrict editing of a range, so that only the input columns can be changed by accident. If several people use the same file, this prevents the most common failure, a helpful person typing over a total. Keep one untouched master copy of the template so you can start again if a version is damaged beyond repair.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

