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.
2 Likes
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.
Read some book on spreadsheets. Any old Excel book of the 1990ies will do.
Formula in S2: =SUM(A2:R2)
Hit Ctrl+Shift+End or enter S2:S250 into the name box left of formula bar.
menu:Sheet>Fill Cells>Fill Down
2 Likes