Home

Using COUNTIFS Criteria

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
=COUNTIFS(Range1,”<>”&”Text1”,
Range2,”<>”&”Text2”)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies