Forum Discussion
SUM cell showing $0.00 instead of formula result
SUM Formula Results show $419.50 but the cell shows $0.00, when clicking on fx to the left of the cell content. I'm summing twelve columns in the same row that are a result of SUMPRODUCT.
3 Replies
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Do you still want the spreadsheet? I’m having a variation if this problem.
I discovered a circular error in another spot in the spreadsheet. The result posted correctly in the cell, once I fixed it. Clearly, I need to look for cell errors before trying to troubleshoot a cell. I'm still revising the spreadsheet, but plan to generalize and clean it once I'm done so I can save it as a template. Would you like me to make it available when I'm done? Regrettably, I neglected to save the damaged spreadsheet and am unable to share it at this point.
