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 could be contributing to this? Thanks
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 could be contributing to this? Thanks Read More
