Formula to count column but exclude information within the column

Ryan Woj

I have a list of Job Classifications that is very long and I need a Countifs formula that can exclude 1 specific job class so that it can count all the others?

heyjay

=COUNTIFS(Range:Range, NOT(CONTAINS("Criteria", @cell))

or use Not Equal sign, <>

Ryan Woj

I have tried the not equal <>

and getting an Invalid Operation error

=COUNTIFS({Action Type}, $[Primary Column]@row, {New/Reclassified reference}, [Column2]$17, {PPB - PA, Recruitment and OL RF Range 1}, NOT(CONTAINS([Column2]$16)))

Paul Newcome

Your CONTAINS syntax is off. You need an @cell reference like so:

=COUNTIFS({Action Type}, $[Primary Column]@row, {New/Reclassified reference}, [Column2]$17, {PPB - PA, Recruitment and OL RF Range 1}, NOT(CONTAINS([Column2]$16, @cell)))