Copper Contributor

I have used Excel for many years and this is the first time that the simple SUM function is adding $320.00 to my total for the column.  The cell is, like always, =SUM(D18:D32) - but when I add the numbers with a calculator this sum is $320.00 less than the total that Excel is calculating.  I am mystified.  I made a deposit with 14 checks and the bank had to remove the $320 from my account.  When I double click on the SUM cell, Excel highlights the correct cells that I want to add but gives me the wrong total.  I checked to make sure all the cells were formatted as currency.  PLEASE Help!

2 Replies
best response confirmed by Hans Vogelaar (MVP)



It is highly unlikely that Excel is adding cells incorrectly.


There's no doubt that it appears to be doing so, but let's face it: with the millions of people around the world that have formulas like =SUM(D18:D32) it just isn't going to happen that you, out of all of them, have the privilege of discovering a major bug in the SUM function.


So what we need to do is look for the source of that number, perhaps a cell that is hidden somewhere... have you hidden any rows in your spreadsheet? Are you using the filter capability?


Is it possible for you to post a copy of the spreadsheet itself on OneDrive or GoogleDrive, with a link pasted here that grants access?

Yikes, I had a row hidden.  My mistake.