Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formulas - Results show an extra 2
I have a very basic SUM formual in my smartsheet. The resulting number is 2 more than it should be. I've cleared the forumla and built it from scratch, and double checked the data in the column. If I handcount, I get the right answer, but the SUM consistently is 2 over. Simiarly, in the next column, I have a COUNTIF formula ... again, 2 over. What am I doing wrong?
Comments
-
First - to check - try to drag and highlight the range you would like to sum up. On the right bottom of the page, you'll see three values in white: count, sum and avg (average). Does it show what you expect or 2 over?
Isn't there a hidden row or something?
If no solution, could you give a printscreen?
-
Thanks for your help!
"On the right bottom of the page, you'll see three values in white: count, sum and avg (average). Does it show what you expect or 2 over?"
YES!! In the sum line at the bottom right, the result is correct. But in the sum line of the formula, it's still off by 2.
What does this tell me?
-
Isn't there a value filtered out? Like here, I have a filter "greater than 1" (the last cell contains a =SUM()):
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives