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,......
COUNITIFS(RANGE1;CRITERIA1)
1 Reply
- TwifooSilver Contributor=COUNTIFS(Range1,”<>”&”Text1”,
Range2,”<>”&”Text2”)