Numbers spreadsheet must have bad numerals
I have a simple spreadsheet with 2 columns in which each row matches but the total at the top does not. How can I attach a spreadsheet? A picture won't do it.
iMac 24″, macOS 15.6
Question marked as
The numeric functions, SUM being one of them, ignore text even if that text looks like numbers. It is likely that you have some text-formatted cells that have "number" characters in them. The usual visual indication is that text naturally aligns to the left side of a cell while numeric data aligns to the right, unless the user has manually changed/set the text justification.
Assuming the two "total" formulas you have at the top are identical (other than the column being summed), I'd start with making sure all the cells being summed are formatted as one of the number formats or as automatic. If any are the result of formulas, make sure the formula results are numeric and not text. If the result has quotes around it, it will be text. A formula like =IF(A1=TRUE, "2", "4") will result in text and will thwart any attempt to format the cell as a number. A formula like = IF(A1=TRUE,2,4) will result in an actual number.