Using COUNTIFS Criteria

Copper Contributor

I want to count the number of occurrences in a range that is not like "TEXT1".  How do you specify e criteria "unlike Text"

The range contains several text-items, eg text1, text2, text3,......

 

COUNITIFS(RANGE1;CRITERIA1)

1 Reply
=COUNTIFS(Range1,”<>”&”Text1”,
Range2,”<>”&”Text2”)