How to write COUNTIFS with a NOT element

I have a working formula for looking up an external reference sheet. All the external fields are tagged with an M:
=COUNTIFS({ReportM}, "Jul 24 - Oct 24", {ProjectM}, Metric@row)

but I now need to exclude a third criterion {ThemeM}, "History"

I tried adding it as

=COUNTIFS({ReportM}, "Jul 24 - Oct 24", {ProjectM}, Metric@row, NOT( {ThemeM}, "History"))

but it returned an INCORRECT ARGUMENT or UNPARSEABLE error.

Grateful for some guidance on the correct syntax to achieve a count that excludes the "History" Theme from the count.

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Try something more like this:

=COUNTIFS({ReportM}, "Jul 24 - Oct 24", {ProjectM}, Metric@row, {ThemeM}, @cell <> "History")

22Wordsmith

Brilliant, thanks, Paul. I just had to remember to reinsert my actual field names!

Paul Newcome

Happy to help. 👍️

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.