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", [email protected]:[email protected]), =true, [email protected]:[email protected], "2")