COUNTIFS AND Criteria on the same criteria range WILDCARD and to exlude

[dluhut]

Given the following data,

How do I do a countifs where I'd like to get TYPE* yet at the same time I'm ignoring certain values, i.e. TYPE-A and TYPE-C?

=COUNTIFS(A1:A10, "TYPE*", A1:AO, "<>{TYPE-A, TYPE-C}")

TYPE-A

TYPE-A

TYPE-B

TYPE-B

TYPE-B

TYPE-C

TYPE-C

TYPE-D

TYPE-D

TYPE-D

[Estevaoba]

Try

=COUNTIFS(A1:A10, "TYPE*", A1:A10, "<>TYPE-A", A1:A10, "<>TYPE-C")

Good luck!