ExcelBanter - Countif data is not all in sequential order

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Countif data is not all in sequential order (https://www.excelbanter.com/excel-discussion-misc-queries/37552-countif-data-not-all-sequential-order.html)

heater

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.

JE McGimpsey

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.

Roger Govier

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

--
Regards
Roger Govier
"heater" wrote in message
...
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.

All times are GMT +1. The time now is 07:09 PM.