COUNTIF Formula Providing Incorrect Result
Hello! I am adding sheet summary fields to count the rows for each status. I noticed that the results I get with my COUNTIF formula are incorrect.
The correct results would be: Completed - 3, In Progress - 1, Not Started - 2 (this one is correct)
I tried this formula on a second sheet and still received an incorrect result.
The correct result for this sheet should be: Complete - 5
Any thoughts on why this might be? The Status column is a single select drop down with conditional formatting.
Help Article Resources
Check out the Formula Handbook template!