formula help

[mikeeee]

Thanks,
I think the 2 formulas will work just didn't know if there was a
shorter way.

 

[Max]

Just another option to try ..

Put the elements you want checked
i.e.: "no info", "11th", "12th" etc (without the quotes)
into a named range, say: TBL

Then try:

=SUMPRODUCT(--NOT(ISNA(MATCH(TRIM('CONTROL GROUP 3'!H6:H313),TBL,0))))