How to write COUNTIFS with a NOT element

22Wordsmith

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.

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. 👍️