Forum Discussion
Sum function
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?
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