I have a Calc spreadsheet that is 18 columns and 250 rows. Not every cell contains data. When I sum the columns and then sum those sums, I get a total. When I sum all of the cells in the spreadsheet I get the same total. BUT when I sum the rows and then sum those sums, I get a DIFFERENT total. I have double-and triple check the sum formulas I am using to be sure they sum the correct cells.
WHY is this happening and what should I look for.
Attach a document demonstrating the issue.
Have a closer look at S188.
And column S is a wild mix of formulas and constants.
1 Like
Thank you SO MUCH. I had been going cross-eyed trying to figure it out, and obviously missed the incorrect format of the SUM for that row despite having rechecked it.
S is a mix because I sum each row separately and when the numbers are small enough I calculate them in my head. I am a novice and self-taught spreadsheet user. There must be a way to more easily sum all of the rows rather than doing it individually, but I haven’t been able to find it.
TWO THUMBS UP for your rapid and very helpful response.