Count Column if cell does not contain

I am working on a sheet summary formula.

The column in question has a formula that will indicate a task is complete based on other criteria. I am trying to calculate the number of rows that are not reading "Complete" in the summary. The formula for that column will return a numerical value for other rows, based on how many days have passed.

=COUNTIF((check:check), <>"complete")

Currently I am getting a return of "0" even thought there are multiple rows that have various numbers in the column.

Find more posts tagged with

Formulas

Sheet Summary

Accepted answers

All comments

Austin Smith

Maybe I misunderstand what you're shooting for, but if you're looking for the total number on NOT "Complete" fields in the column

=Count([check]:[check])-Countif([check]:[check],"Complete")

strobn

https://community.smartsheet.com/discussion/comment/368893#Comment_368893

Thank You @Austin Smith! Greatly appreciated!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.