Home

Using COUNTIFS Criteria

Highlighted
Knuffe
Occasional Visitor

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
Highlighted
=COUNTIFS(Range1,”<>”&”Text1”,
Range2,”<>”&”Text2”)
Related Conversations
COUNTIF not working
sme527 in Excel on
10 Replies
Totaling using two sets of data
dazedandconfused in Excel on
2 Replies