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.
Best Answer

Ok. Let's try something different.
Apply a filter to only show rows where the Status is "Complete". How many rows are displayed?
Answers

Hi @kelceyg
Could it be a range issue? If you click onthe formula it will highlight the range of the column that the formula is reading.
Did this solve it? Yes/No?

The formula is looking at the correct range. I want the formula to look at the Status column and provide the total count of each status. I double checked the column and I should only have a total count of 3 for "Complete." The result I'm given with my formula is 4.
=COUNTIF(Status:Status, = "Complete")

Make sure there are no filters applied to the sheet. Also turn off the conditional formatting to make sure there are no entries that are hidden.

I have disabled all of my conditional formatting and have ensured that I do not have a filter on, but I am still getting incorrect results for my "Completed" and "In Progress" counts.

Ok. Let's try something different.
Apply a filter to only show rows where the Status is "Complete". How many rows are displayed?

Hi Paul!
Using the filter, I discovered that I had a collapsed child rows that had Statuses of Complete and In Progress! Now I am receiving the correct results in my formula!

Help Article Resources
Categories
Check out the Formula Handbook template!