COUNTIFS not working correctly with dropdown critierion

I am using the following formula to count the number of rows that have both [Pricing] unchecked and [Status] showing any other value EXCEPT "Not Applicable.

=COUNTIFS(Pricing:Pricing, 0, Status:Status, <>"Not Applicable")

When I use the above formula, it keeps showing the incorrect value.

I've filtered the sheet using the same criteria (Pricing is unchecked and Status is not one of "Not Applicable") and it manages to show the correct value.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Try this:

=COUNTIFS(Pricing:Pricing, @cell <> 1, Status:Status, <>"Not Applicable")

Joe D

I pasted in that formula and it still didn't work. Does it matter of some of the Status fields are blank?

Paul Newcome

Would you want the blanks included or excluded from the count?

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.