find count if column has values that starts with certain texts

[linok]

Hi Guys,

I need help in generating excel formula to find out count if column has values that starts with certain texts.
I know I can do it using

Please Login or Register  to view this content.

but there are other conditions as well along with this condition.

please find attached sample file with data.

Appreciate your help.
Book1.xlsx

[linok]

looks like I found the solution for this:

Please Login or Register  to view this content.