What's wrong with my formula?

Grace Tidwell

=COUNTIFS(Position2:Position196, CONTAINS("Medical Assistant", @cell), [Cleared to Return?]2:[Cleared to Return?]136, OR(CONTAINS("No", @cell), CONTAINS("Contingent", @cell)))

L3X0R

Mike Wilday

Your ranges are different sizes. You need to make sure the ranges are the same. Here is the revised version. Does this work?

=COUNTIFS(Position2:Position196, CONTAINS("Medical Assistant", @cell), [Cleared to Return?]2:[Cleared to Return?]196, OR(CONTAINS("No", @cell), CONTAINS("Contingent", @cell)))