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