title: COUNTIF/COUNTIFS workaround to calculate a number of positive cell-pairs in a line
body: <p>I've got the following task:</p>
  
  <p>Given 16 columns with stock and 16 columns with sales, each of which represents a week (<strong>|Stock1...Stock16|Sales1...Sales16</strong>), basically, 16 pairs of Week_num_stock/sales. </p>
  
  <p><a href="https://i.imgur.com/crV8kcu.png" rel="nofollow noreferrer">https://i.imgur.com/crV8kcu.png</a></p>
  
  <p>I have to calculate the number of weeks, when stock or sales or both were positive (<strong>Stock>0/Sales=0</strong> | <strong>Stock=0/Sales>0</strong> | <strong>Stock>0/Sales>0</strong>), in other words, a number of pairs Stock-Sales that are positive with the possible maximum of 16 (as it is the number of weeks given). </p>
  
  <p>The problem I am stuck with is: if I use <strong>countif</strong>, it just calculates the number of positive cells, and <strong>Stock>0/Sales>0</strong> counts as two positive cells and in the end, I get the wrong results. And I struggle to find a workaround for that. </p>
  
  <p>Hope you guys can help me. Thanks.</p>