Is there such a thing as COINTAINSIF?

Phil Wightman

Which function do I use to count the number of times certain letters eg PRJ and TRN appear in a range if in another column the project is open (not closed).

Jeff M.

You would want to use COUNTIFS(CONTAINS( for your formula. I provided an example below. Let me know if you have any issues.

=COUNTIFS(CONTAINS("Red", Color@row:Color@row), =true, Number@row:Number@row, "2")