Problem with COUNTIF and wild character

[alex_a]

Good Morning,

I have the follwoing data in column C and D. in the C column i have multiple codes all of them start with the word QC. I need to count the numebr of "yes" in the column D. I am using an array formula like this:
SUMPRODUCT(C1:C20="QC*")*(D1:D20="Yes"). I get an erroo message (#Name!). What is wrong with this formula? Thanks.

 

[alex_a]

=SUMPRODUCT(--ISNUMBER(MATCH(LEFT(C1:C10,2),{"QC",""},0)),--(E1:E10="Yes"))

My sincere gartitude to everyone helping me to solve my problem. My special thanks to Aladin with his magic stuff! Issue was resolved!