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.
=COUNTIF('All Defects'!I:I,"<>Closed")
10 Replies
If you're using Excel 365, you could use:
=SUM(N(TOCOL('All Defects'!I:I,1)<>"Closed"))Hi, How can I add another variable to this formula (i.e. Sum all defects that are "not closed" AND "deferred"? Thanks
- This worked perfectly! Thanks
- Glad I could help. You're welcome!
