COUNT IF + NOT CONTAIN

mcc

I am using the formula below and the NOT CONTAIN is not working. Could anyone help?

COUNTIFS({Spreadsheet_1 Range 3}, "John Smith", {Spreadsheet_1 Range 1}, "In Progress", {2023 Spreadsheet_1 Range 2}, NOT(CONTAINS(@cell, Maintenance))

Jason Tarpinian

Two things .1: CONTAINS() syntax is as below, the search_for is your first value, then your search_within will be your next value. 2: Whenever you use text in a formula, make sure to wrap it in quotes. You'd done this with the first 2 criteria, looks like you just forgot for the 3rd.

So your final formula should look like this:

COUNTIFS({Spreadsheet_1 Range 3}, "John Smith", {Spreadsheet_1 Range 1}, "In Progress", {2023 Spreadsheet_1 Range 2}, NOT(CONTAINS("Maintenance", @cell)))