Countif data is not all in sequential order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for the LESSER of 2 Calculations 4
Vlookup Reference Certain Worksheets 4
Excel Need Countifs Formula Help 0
COUNTIF Cells in Range? 4
Countif formula 2
mmb- fiscal year calculation-- 2
Referencing External files with slightly different names 4
Countif/Vlookup 2

Back
Top