Count if the cell linked value is not "Complete"

Hi I am having troubles with a formula that is supposed to count every cell in a cell link that does not contain the value "Complete". The formulas that I have tried to use are =COUNTIFS({HelperCA}, "Executed Batch Record ALN", {StatusCA}, NOT(Complete))

and

=COUNTIFS({HelperCA}, "Executed Batch Record ALN", NOT({StatusCA}="Complete"))

where is my formula going wrong?

Thanks in advanced! 😊

Find more posts tagged with

Accepted answers

All comments

ericncarr

I think you want it this way:

=COUNTIFS({HelperCA}, "Executed Batch Record ALN", {StatusCA}, <>"Complete")

The way the Countifs function works is by giving it multiple ranges and criteria. So in this formula you give it the range HelperCA (assuming a column in the other sheet...) and the criteria that it be equal to "Executed Batch Record ALN." Then you give it another range, StatusCA, and give it the criteria that it not be equal to "Complete" using the <> symbols. That way it knows to count only rows that meet the criteria given for both ranges.

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.