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?
Below is the heading. I've recreated this slicer multiple times and can't get rid of this duplicate. I did notice that in the pivot table, the duplicate is reflected also and again, this does not reflect the data source which lists Assigned only once.
