COUNTIFS Question

I am trying to do a count if formula that counts everything in my column except 6 specific words. Here is the formula I am trying to use.

=COUNTIFS([SEA#]:[SEA#], OR(@cell <> "WAS11", @cell <> "WAS14", @cell <> "WAS15", @cell <> "WAS16", @cell <> "WAS25", @cell <> "WAS26"), [Date Requested]:[Date Requested], AND(@cell >= DATE(2020, 4, 1), @cell <= DATE(2020, 6, 30)))

It is calculating, but it is still pulling everything in that column in that date range. It isn't pulling out my specified words.

I would appreciate any insight! Thank you!

Find more posts tagged with

Accepted answers

All comments

Mark Cronk

Hi @Megan Harry ,

Try:

=COUNTIFS([SEA#]:[SEA#], AND(@cell <> "WAS11", @cell <> "WAS14", @cell <> "WAS15", @cell <> "WAS16", @cell <> "WAS25", @cell <> "WAS26"), [Date Requested]:[Date Requested], AND(@cell >= DATE(2020, 4, 1), @cell <= DATE(2020, 6, 30)))

Mark

Megan Harry

@Mark Cronk Thank you Mark! I see AND instead of OR is the way to go for this one. This worked perfectly. I really appreciate the help!

Mark Cronk

Hi Megan,

Happy to help. Thanks for contributing to the Community.

Mark

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.