When Apple Numbers seems broken, the problem usually falls into one of two groups: the file will not open or sync, or the sheet opens but the totals are wrong. For the first, update the app, check the sign-in and storage, and try opening the same file on another device. For the second, the usual culprit is amounts stored as text, which a total quietly ignores. Menu names and settings change, so use the company's own help page for exact steps.
The file will not open or will not sync
Start with the boring checks, because they fix most cases.
- Update the app and the phone or laptop system, since an old version can fail on a file saved by a newer one.
- Confirm that you are signed in to the same account on both devices.
- Check free storage on the device and in the cloud space the file is kept in.
- Try another device or the web version to see whether the file itself is fine.
- Look at the company's service-status page in case it is a wider problem.
If a file opens on one device only, copy it out to another place straight away before changing anything else. A second copy costs nothing.
Why does my total show zero when the numbers are right there?
Spreadsheets treat a cell as text if it holds anything beyond a plain number. A rupee sign, a comma in 1,200 or a trailing space can turn an amount into text, and a SUM ignores text. Say a small grocery sheet looks like this:
| Item | Entered as | Counted by SUM? |
|---|---|---|
| Vegetables | ₹340 | No, rupee sign makes it text |
| Milk | 62 | Yes |
| Rice | 1,250 | Maybe, depends on how it was typed |
| Oil | 480 | No, trailing space |
Only the 62 is certain to be counted, so a SUM of the column might show 62 when the real total is 340 + 62 + 1,250 + 480 = ₹2,132. The fix is to retype the cells as plain numbers and format the column as currency afterwards, so the rupee sign is a display choice, not part of the value.
Which formulas should I trust for an expense sheet?
The same ideas work in Excel, Google Sheets and Numbers, though each app words the function help differently. For Numbers, check the in-app function list for exact argument order. A useful starter set, with dates in column A, categories in column B and amounts in column C, rows 2 to 500:
- =SUM($C$2:$C$500) for the grand total
- =SUMIF($B$2:$B$500,"Food",$C$2:$C$500) for one category
- =COUNTIF($B$2:$B$500,"Food") for how many Food rows there are
- =AVERAGE($C$2:$C$500) for the typical row, though that is a row average, not a monthly one
If a formula shows its own text instead of a result, the cell is formatted as text. Change the format, then re-enter the formula.
Is it the app, the file or me?
A quick test separates the three. Open a brand-new blank sheet and type 2 in one cell and 3 in the next, then add them. If that works, the app is fine and the old file has a cell or format problem. If the blank sheet also fails, the app or the device needs attention. If it works on another device, it is the first device.
Keep a dated copy of the working file each month, such as expenses-2026-10. If a sheet corrupts, you lose a week, not a year.
When the sheet stops being enough
Spreadsheets are a good way to learn what your spending looks like. They get heavy when you add three bank accounts, a card and a few cash spends each week, because every row is typed or pasted by hand. At that point an expense tracker can take over the data entry. SpendixAI takes bank and card statements as PDF, CSV or Excel and shows the rows for review before saving, and it exports reports to CSV, so your sheet habit and the app can sit side by side.
Do the formulas properly first. Knowing how SUMIF works makes any tracker's report easier to question.
Quick rescue list
- Update the app and sign in again.
- Copy the file to a second location.
- Test a blank sheet to find where the fault is.
- Convert text amounts into numbers.
- Format as currency after the values are clean.
- Compare the total to a statement before you trust it.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

