CountIf Depending on horizontal and vertical criteria

Try

=SUMPRODUCT(--(I2:AN31="Y"),(E2:E31="M")*ISNUMBER(FIND("L2",I1:AN1)))

Note: FIND() is case-sensitive. If you need to look for "l2" as well, replace FIND with SEARCH.