Sum error in numbers

Question

Level 1

4 points

Sum error in numbers

Hi, on a very simple spreadsheet in numbers, it is adding up my values incorrectly on my macbook pro. I have checked the format in the column they are all "numbers" not texts. so not sure why it comes up with exactly 12 more than it should be. The value should come to 580, not 592.

(I am also running the exact spreadsheet in parallel in google sheets, and google sheets adds up the sum correctly, that's how I know how much it should be)

could I send you the sheet to work out what is wrong? - Thanks

Posted on Jun 28, 2023 5:06 AM

Reply

Answer 1

Top-ranking reply

Nikoltai85 Author

Level 1

4 points

Jun 28, 2023 7:59 AM in response to pjswiz

DOHH ! I found what the problem was, there was a hidden row, which shouldnt have been there, Row 8! I clicked on unhide all rows, and that row had a value of 12! I thought it was too peculiar that this spreadsheet was exactly 12 more than the other one!

Thanks for your help anyway!

Reply

Answer 2

pjswiz

Level 5

5,366 points

Jun 28, 2023 6:09 AM in response to Nikoltai85

Hello Nikoltai85,

Could you please click on the 592 so I can see what formula you're using.

When adding the SUM() of an entire row, I'd suggest just using Footer Rows.

Add a footer row below the table (This row will always remain at the bottom no matter how many rows you add). Then all you have to do is type =SUM() and then within the parenthesis just click on the entire column, by clicking the C

Reply

Answer 3

Barry

Level 9

59,951 points

Jun 28, 2023 11:14 AM in response to Nikoltai85

"… there was a hidden row…"

Triple DOHH (at least); pgswiz and I both missed that hidden row on reading your question and the included screen shots.

Happy to see you found the cause!

Regards

Barry

Reply

Sum error in numbers

Similar questions