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.

Find more posts tagged with

Formulas

Sheet Summary

Accepted answers

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?

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.