Only count items that aren't marked "complete" in the status column.

Hello All,

I am hoping someone might be able to help me w/ my formula? I'd like it to only count items that aren't marked "complete" in the status column. This is what I have so far:

=COUNTIFS({Remediations Category}, "NEC VIOLATION - ARC FLASH FAILURE", {Remediations Core OPCO}, "NSP", {Remediations Year}, "2022", {Remediation Status} I am not sure what to do here)

Any help or advice with this would be great - thanks in advance!

Find more posts tagged with

Accepted answers

All comments

Purnima Gore

You can use the <> which means Not in the formula

=COUNTIF(Status:Status, <>"Complete")

Let me know if that helps :-)

Kind regards

Purnima

Project GPS

PKane

Thank you very much, Purnima for your reply! I am pretty new to formulas, and wanted to ask -

Should the formula look something like this?

=COUNTIFS({Remediations Category}, "NEC VIOLATION - ARC FLASH FAILURE", {Remediations Core OPCO}, "NSP", {Remediations Year}, "2022", {Remediation Status} Status:Status, <>"Complete")

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.