one way:

=COUNTIF(Q31:Q91,"Yes") + (Q109="Yes") + COUNTIF(Q124:Q126,"Yes")


In article ,
heater wrote:

I need a formula that will sum if the cell is "Yes" from q31:q91 and if cells
q109 and q124:q126 are "Yes". I need to skip a few cells. I have -
COUNTIF(Q31:Q91,"Yes"), but need to add q109 and q124:q126. Thanks.