Forum Discussion
Sum function
Sum of my columns is coming up 0 or 0.00 although I've used the same function for years. Why is this happening??
8 Replies
In the absence of any more details, it's hard to know for sure. One possibility is that the numbers you're adding are in fact not seen by Excel as numbers, but as text.
But for any more definitive explanation, you'd help us help you by posting a copy of the spreadsheet in question on OneDrive or GoogleDrive, with a link here that grants access. If all the data are confidential, then a modified version, having deleted or changed such things as names. If no file can be shared, an image....if not that, let us at least see the formula that is now producing this zero result, though that would still leave a lot of questions dangling.
- I loaded the file to One Drive. how do I grant access to you?
I loaded the file to One Drive. how do I grant access to you?
With the file open on OneDrive, click on "File" in the menu bar at the top. You should then see something like the display below. Go down to "Share" and then click on "Copy Link to this Workbook"
And then use Paste to paste that link into a message/post here
- The row function with SUM, but not the columns. I did get one column to work, but not the others. The zeros in the columns were entered with "find and replace." I'm still trying to upload to ONE DRIVE
- How can I convert those numbers from text to numbers, if that's the problem.
How can I convert those numbers from text to numbers, if that's the problem.
Assuming, for illustration sake, that the errant cells are in column A, in an adjacent column enter something along the lines of =VALUE(A1) and copy that down to all needed rows. That will convert text values to true numbers.
(I frequently download data from a bank, credit card transactions and the like, and use a formula like that to convert to all true numeric values.)
