View Single Post
  #1   Report Post  
heater
 
Posts: n/a
Default 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.