sum = 0 in error

pdmartin58

New Member
Joined
Sep 4, 2016
Messages
20
I have a column of numbers that sums erroneously to 0. If I add each cell A1+A2+A3, etc it returns the correct value but the sum function always returns 0. I've ensured that all the field formats are numerical. Any ideas what's causing this problem?
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
It's still possible to have a number stored as text in a cell formatted as General, or some number format. Try this and see what happens:

=SUMPRODUCT(A1:A3+0)
 
Upvote 0
I've ensured that all the field formats are numerical.
That won't matter if the entries were entered as Text. Changing the field format after it has been entered will have no effect on it.
What does this formula return?
=ISNUMBER(A1)

If it returns FALSE, you have text entries, not numerical ones.
You can use Text to Columns on column A to convert those all to numbers.
 
Upvote 0

Forum statistics

Threads
1,213,520
Messages
6,114,101
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top