Excel sum not adding up? See which cells are wrong.
It reads every formula and total, names the cell that is wrong and gives you the fix. It runs inside your own SheetTamer office.
Free for 30 days. No card. The check stays free after that.
Already have an office? Sign in
sample.xlsx
B9 reads $610 too low. E6 is flagged for you to confirm.
Total expenses is off by $610. B9 is typed in as 7,975, and the five rows above it sum to 8,585. E6 is a typed in number in a column of formulas, so it will not update.
| Category | Jul | Aug | Sep | Q3 total |
|---|---|---|---|---|
| Sales | 18,450 | 19,200 | 17,875 | 55,525 |
| Supplies | 1,240 | 1,315 | 1,190 | 3,745 |
| Part time wages | 4,800 | 4,800 | 4,800 | 14,400 |
| Rent | 1,650 | 1,650 | 1,725 | 4,9502 |
| Vehicle and fuel | 610 | 655 | 590 | 1,855 |
| Phone and software | 285 | 285 | 285 | 855 |
| Total expenses | 7,9751 | 8,705 | 8,590 | 25,270 |
| Net profit | 10,475 | 10,495 | 9,285 | 30,255 |
- 1Q3 P&L!B9B9 reads 7,975, but the 5 values above it sum to 8,585. Replace the typed value in B9 with =SUM(B4:B8).
- 2Q3 P&L!E6E6 is a typed in number, but E5 above it is a formula, =SUM(B5:D5). I add B6 to D6 and get 5,025 where E6 reads 4,950. Confirm E6 should be calculated, and if so put =SUM(B6:D6) back.
What the checker looks for
Five checks on every sheet, each finding named by cell, with the fix.
- 01
- 02
A number typed over a formula
A typed figure in a column of formulas, so it never updates.
E6 in the example - 03
Figures that do not tie
A figure that disagrees with the sheet it points at.
- 04
Error cells
#REF!, #VALUE! and the rest, by cell.
- 05
Formulas that break the pattern
One formula doing something different from its neighbors.
How it works
- 01
Set up your office
Your email and your name. No card.
- 02
Enter the code
We email six digits. Typing them in proves the address is yours.
- 03
Check your file
Open Check a workbook and pick it. The report stays in your office.
Questions
Why is my Excel sum not adding up?
The usual causes are a total typed over its formula so it no longer updates, a range that leaves out a row, and a broken reference such as #REF!. The checker finds each one and names the cell.
What does the checker look for?
Five checks: totals that do not add up, figures that do not tie to the sheet they point at, error cells, numbers typed over formulas, and formulas that break the pattern.
Is the check free?
Yes. Your office is free for 30 days with no card, and the check stays free after that.
Why do I sign in to check a file?
So the report is yours. It sits in your office behind your email, and it is there when you come back.
What happens to my file?
Your spreadsheet stays on your device. The check runs in your browser, and we receive only the findings: the file name, the cell, the type of problem, the amount involved and a plain English note, which can quote figures from the file. You can turn the note and the amount off in settings. We never get the workbook.
Find the wrong cell before anyone else does.
Check my spreadsheet free →Free for 30 days. No card.
Are you an accountant? Set up your firm free