Sum FUnction Not working properly
I am trying to get the total value for a column and the math is completely off. has anyone encountered this? all i am doing is a simple sum. the total should be 703 not 595
Answers

Can you try to remove the numbers one by one and see what row/number is not affecting the formula.
When you remove the number bring it back when you jump on the next row.
...

Hello, I came here looking for an answer to a similar problem. Didn't find it here but I did figure it out eventually.
I was pulling numbers from other sheets into my formula which was not calculating as expected.
My fix was to make sure each cross sheet reference was converted from text into a number using VALUE(yourreference@row) in the cell where I had my formula.
I know this is an old thread. Just leaving this here in case someone else needs it.
Jim
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!