title: COUNTIF with multiple OR-criterias in different columns
body: <p>I have the following Excel spreadsheet:</p>
  
  <pre><code>       A          B               C         D        E        F         G
  1               Profit           1.Sales  2.Sale   3.sale     
  2   Product A     50              500       600       0      Product A   2
  3   Product A     60                0       400       0      Product B   1  
  4   Prodcut A     20                0         0       0      Product C   2
  5   Product B     90              800         0       500
  6   Product C     80                0         0       400
  7   Product C     50              300       750       200
  8   =""           =""             =""        =""       =""
  </code></pre>
  
  <p>In <strong>Column A</strong> different products are listed. <em>It can happen that the same products appear several times in the list.</em> In <strong>Column B</strong> you can find the budgeted profit for each product and in <strong>Columns C:E</strong> the different sales of each product.</p>
  
  <p>In <strong>Column G</strong> the <strong>number</strong> of profits for each product is shown in case the product has any sales. For example <strong>Product A</strong> has no sale in Row 4; therefore the <strong>number</strong> of its profit is B2 and B3 = 2.</p>
  
  <p>To get right number in <strong>Column G</strong> I tried to go with the following formula:</p>
  
  <pre><code>=COUNTIFS($A$2:$A$7,F2,$C$2:$C$7,"&gt;"&amp;0,$D$2:$D$7,"&gt;"&amp;0,$E$2:$E$7,"&gt;"&amp;0)
  </code></pre>
  
  <p>But instead of the AND-criterias I would need OR-criterias.</p>
  
  <p>How can use OR-critierans in this COUNTIFS function?</p>