Forum Discussion

Knuffe's avatar
Knuffe
Copper Contributor
Mar 08, 2019

Using COUNTIFS Criteria

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

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    =COUNTIFS(Range1,”<>”&”Text1”,
    Range2,”<>”&”Text2”)