Sum/calculating error in Numbers
Hi guys,
I’ve been using Numbers to track finances, using the “sum” option to add up all the expenses in the table at the end of the month.
I recently started using the app Notion, and prefer that better for tracking expenses, so will be switching to that from now on.
As it’s the end of the month I was just calculating some totals and there was a discrepancy between both apps, despite having the exact same data.
I’ve just wasted over an hour or so going through every single section/row confirming no data was missing and added everything manually, cross-referencing etc to see where the error was.
I discovered that when I use the “sum” action in Numbers it’s showing an incorrect total, however when I add every number myself (manually) I received the correct amount (which also matched the amount from Notion).
Very frustrated as I’ve been relying on Numbers for over a year to calculate expenses, I had no reason to consider that it’s “sum” action might show incorrect totals.
So just to summarise, when I highlight all the numbers/rows and press ‘sum’ it gives me a different total to what I’d get if I just added each one myself. It’s giving me the incorrect sum, as I’ve re-calculated manually many times now (and even so, the amount I manually get also matches the auto-sum in Notion).
Is there a known error with the ‘sum’ action? I definitely can’t rely on it anymore so will just use Notion from now on, just asking if any one else has had this issue, or why it’s even possible when the data isn’t being altered, whether I auto-sum or manually sum using the exact same numbers it should of course total the same.
Any thoughts greatly appreciated.
