Formula to Count multiple text values in a range

SJTA ✭✭✭✭
edited 01/26/24 in Formulas and Functions

I have 2 columns/ranges.

I need to count if range1 is value text1 and range2 has values text2, and text3, and text4.

This formula works so far =COUNTIFS([Range1]:[Range1], "Text1", [Range2]:[Range2], "Text2")

However things get wonky when I wan to add more text values to Range 2. So it would kinda look like below. But nothing I am trying is working so far.

=COUNTIFS([Range1]:[Range1], "Text1", [Range2]:[Range2], "Text2", and "Text3", and "Text4")

Please help. Thanks!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!