Forum Discussion
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. =COUNT...
Apologies, I think i was responding to the slicer question in my earlier reply. If it's counting the header, how do i exclude it? Also, I have other formulas referencing the "I" column and the counts are accurate. Another question, what does the "1" (in red) in the below formula represent? Again, Thanks for all of your help.
=SUM(N(TOCOL('All Defects'!I:I,1)<>"Closed"))
TOCOL converts an array to a vertical column. The '1' tells the function to ignore blanks when converting the array. It's one way to remove the blanks before the counting is done.