Google Sheets problem

Factual Questions
1

I was addied up a column of numbers in Google sheets, and sent the result to my boss. He emailed me back, saying the total was wrong. I double and triple checked, and my boss was correct. The sum function was skipping one of the cells (B692) in the middle of the column.

I checked the column next to it, and the same thing happened. The sum function skipped C692.

If I used the sum function to add the two cells across (B692 + C692), the answer was 0.

Any idea what the cause would be for this? The cell, row, and column don’t seem to be formatted any differently than any of the other cells, rows, and columns.

2

Try selecting that entire column and then clicking on Format -> Number -> Number. Does that help?

3

Yes, it did. Thank you!

I still don’t know how two cells were formatted differently than the rest of the sheet. Someone else must have gone in and fooled around with the formatting.

4

Yeah, or maybe it was an import problem. Stray characters (random spaces, punctuation, formatting marks, other languages, etc.) can really eff things up… it’s finicky

5

This was my first thought as well. When is a number not a number? When it’s a string or some such in a cell.