Broken formulas and misaligned rows in comparison sheets
-
Numbers stored as text in a spreadsheetWhy a spreadsheet keeps numbers stored as text, how to spot the green triangle warning, and the fastest ways to convert a whole column back to real numbers.
-
Why a SUM formula is not working in a spreadsheetSee why a SUM formula returns a wrong total or no result in Excel or Google Sheets, and learn how to fix text numbers, error cells and manual calculation.