Hi Misca, that works perfectly.. thanks.Is =COUNTIF(Range,"2FT?") good enough?
Hi Njimack, thanks for your quick reply. That formula is a bit beyond my level of understanding unfortunatley, but thanks for replying.Confirmed with ctrl+shift+enter:
=COUNT(IF(ISNUMBER(MATCH(Range,{"2FTC","2FTF","2FTP"},0)),1,0))