COUNTIF Formula Providing Incorrect Result

kelceyg

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.

Paul Newcome

Ok. Let's try something different.

Apply a filter to only show rows where the Status is "Complete". How many rows are displayed?

Phil Wightman

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?

kelceyg

Hi @Phil Wightman

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")

Paul Newcome

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.

kelceyg

Hi @Paul Newcome

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.

Paul Newcome

Ok. Let's try something different.

Apply a filter to only show rows where the Status is "Complete". How many rows are displayed?

kelceyg

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!

Paul Newcome

Excellent. Glad you were able to get it working.