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()):