SOLVED

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

# Re: SUM FUNCTION ADDS INCORRECTLY

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?

# Re: SUM FUNCTION ADDS INCORRECTLY

Yikes, I had a row hidden.  My mistake.

1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution

# Re: SUM FUNCTION ADDS INCORRECTLY

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?