Hello,
Using this example set of data:
A B
John 1
Mary 6
Bill 7
John 5
Rob 10
Jim 2

How would a formula look that wants to count anything in column B greater
than 5, and anything in column A that is equal to either John, Mark, or Jim?
I know I could do 3 separate countifs and add them together, but my real
excel sheet is much more complicated than this. Just wondering if there is
some sort of "OR" function that can be used in this situation with countifs.

Thanks!