Countifs using a Or Function

Can someone please tell me what the formula for the following criteria would be please:



If Range 1 or 2 has a value of @cell, then count the occurances

Any help would be very helpful.

Many thanks


Best Answers



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!