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
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives