SOLVED

SUM FUNCTION ADDS INCORRECTLY

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 HansVogelaar (MVP)
Solution

@Jean_Russell 

 

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.

@Jean_Russell 

1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution

@Jean_Russell 

 

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?

View solution in original post