Countifs using a Or Function

Paul Newcome

@Michael Foster Happy to help. 👍️

The reason the OR function doesn't work is because the OR needs to have a logical statement which includes some kind of criteria whereas the placement of the OR that you would have needed within this particular COUNTIFS would have been in the range section (no criteria).

Now if you had wanted to specify two different criteria for the same range, then you could have used the OR in the criteria section.

=COUNTIFS({Range}, OR(@cell = "Paul", @cell = "Mike", @cell = "Michael"))

Mike Wilday

👍️