Try

=SUMPRODUCT(--(ISNUMBER(SEARCH({"X","Y","Z"},aktual_meno))))