User Profile
Fickle_Frog
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
[SOLVED] Sum function returning 0.00 instead of total
In an excel document I have previously had no issues with, any new SUM functions I use, even on existing data, return 0.00 rather than the correct total. I have ensured data is formatted as numbers not text and yet any new attempts at using SUM or manually adding (e.g. =A1+A2+A3...) return 0.00, even though old =SUM functions in the document work until clicked on, then subsequently returning 0.00 as well. Does anyone know why this might be happening or how to resolve this issue? Edit: Saw a mention of circular arguments on another forum and the issue ended up being that the =SUM formulas were automatically including the cell the formula was in as well, causing an error. Problem fixed now but odd it happened.23KViews0likes2Comments
Recent Blog Articles
No content to show