countifs with multiple criteria NOT equal to

I'm trying to create a formula to count a dataset if not equal to multiple criteria:

=COUNTIFS({TTKENG 2021 RoadMap Priority}, "Red", {TTKENG 2021 RoadMap Range 3}, <>"9 Released", {TTKENG 2021 RoadMap Range 3}, <>"X On Hold", {TTKENG 2021 RoadMap Range 3}, <>"Z Rejected")

I want to count all EXCEPT those items "9 Released", "X On Hold" and "Z Rejected". This is giving me a number, but it isn't calculating correctly. Any suggestions?

Find more posts tagged with

Accepted answers

Paul Newcome

Could it possibly be including blank rows in the count? If so, add in another range/criteria set where the criteria is

<> ""

All comments

Paul Newcome

Could it possibly be including blank rows in the count? If so, add in another range/criteria set where the criteria is

<> ""

Angie Little

It wasn't counting blanks and I wanted them too so I modified your suggestion to use "" but without the <> and it worked! Thank you!

Paul Newcome

Happy to help. 👍️

Sarita Sah

@Paul Newcome, could u pls suggest what is wrong with my formula. I want to count the number of other values available in a column other than "Kentico 13"

=COUNTIFS({Testing Log Raw Range 1}, "2023", {Testing Log Raw Range 2}, "IAT", {Testing Log Raw Range 7}, <>"Kentico 13")

Paul Newcome

@Sarita Sah Are you able to provide a screenshot of the source data? There are no immediate issues with your formula, so we are going to have to dig in a little bit more.

Sarita Sah

@Paul Newcome Sure, I have this data in a Smartsheet for last 3 years for IAT and UAT, I am counting only for IAT and only for 2023 for "Kentico 13" which is available in the Kentico column.

Paul Newcome

What happens if you remove the quotes from around 2023 in the COUNTIFS?

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.