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...
This worked perfectly! Thanks
Glad I could help. You're welcome!
- for some reason, this count using the below formula is one more than when i filter on the column.
=SUM(N(TOCOL('All Defects'!I:I,1)<>"Closed")). This count is 173 when the actual count is 172. Any idea of what could be contributing to this? Thanks- Could it be counting the header at the top of the column?
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"))