| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
=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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing blank rows in a worksheet | Excel Worksheet Functions | |||
| Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
| How do I set the order of calculation of Data Tables in Excel? | Excel Worksheet Functions | |||
| Is there a VLOOKUP substitute when data is not in ascending order | Excel Worksheet Functions | |||
| Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions | |||
Hybrid Mode
