Count if function
Trying to count all cells in a column that are not “Closed” and also excluding the counting of any blank cells. The below formula gives me a count of over 1 million when it should be 178.
=COUNTIF(‘All Defects’!I:I,”<>Closed”)
Trying to count all cells in a column that are not “Closed” and also excluding the counting of any blank cells. The below formula gives me a count of over 1 million when it should be 178. =COUNTIF(‘All Defects’!I:I,”<>Closed”) Read More
