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