Can the formula below work, I get a #Value! returned so I assume I
have a syntax wrong. Tried entering as an Array, but still the same. I
know =COUNTIF(C12:C14,"Yes") works but I want to skip C13

=COUNTIF((C12,C14),"Yes")