Forum Discussion
Knuffe
Mar 08, 2019Copper Contributor
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,...... C...
Twifoo
Mar 08, 2019Silver Contributor
=COUNTIFS(Range1,”<>”&”Text1”,
Range2,”<>”&”Text2”)
Range2,”<>”&”Text2”)