Countif data is not all in sequential order

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.

one way:

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


In article <0A0D9EBA-22D8-4578-9644-69F500C492BB@microsoft.com>,
heater <heater@discussions.microsoft.com> 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.

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


--
Regards
Roger Govier
"heater" <heater@discussions.microsoft.com> wrote in message
news:0A0D9EBA-22D8-4578-9644-69F500C492BB@microsoft.com...
>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.