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.
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.