On Wed, 6 Feb 2008 03:56:32 -0800 (PST), Sean wrote:

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")

=(C12="Yes")+(C14="yes")


--ron