Sum function

[JulesE1122]

Sum of my columns is coming up 0 or 0.00 although I've used the same function for years. Why is this happening??

[#2]

@JulesE1122 

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.

[#3]

Thank you. I'll try to post a copy. It's not confidential.

[#4]

How can I convert those numbers from text to numbers, if that's the problem.

[#5]

@JulesE1122 

In addition to @mathetes idea check the cells with ISTEXT() or ISNUMBER().

[#6]

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

[#7]

I loaded the file to One Drive. how do I grant access to you?

[#8]

@JulesE1122 

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.)

[#9]

@JulesE1122 

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