Cell arithmetic not correct

I've found that some of my cells aren't adding or subtracting the way I thought they should.

I have a sheet that caluclates using Countif formulas. Generally everything is correct, except for the cell in yellow.

You'll see that the cell above is returning "6" based on the following (6 minus 3)

In my mind the result should be "3" not "6". Any thoughts why this is occuring?

I play around with changing the formula to select other cells in the column, sometime the maths is correct, other times not. Quite weird.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!