Forum Discussion
Solved
SUM formula calculating 1 more than actual
The count formula below is calculating one more than when i filter on the column. =SUM(N(TOCOL('All Defects'!I:I,1)<>"Closed")). This count is 174 when the actual count is 173. Any idea of what cou...
That's okay if the value in I1 is not "Closed".
=COUNTIFS('All Defects'!I2:I100,"<>Closed",'All Defects'!I2:I100,"<>") =SUM(N(TOCOL('All Defects'!I2:I100,1)<>"Closed"))
Hi Lisa, here's a breakdown of the formula. It's possible some of your cells may have a space or two.