title: Google Sheets SUMIF and ArrayFormula
body: <p><a href="https://i.stack.imgur.com/J8G2T.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/J8G2T.jpg" alt="Data example" /></a></p>
  <p>What I'm trying to do is to sum row 1 in column D if A3:C has a value. The blue cells in the image shows the values I'm trying to calculate.</p>
  <pre><code>=SUMIF(A3:C3;&quot;&gt;0&quot;;$A$1:$C$1)
  </code></pre>
  <p>or</p>
  <pre><code>=SUM(FILTER($A$1:$C$1;A3:C3&gt;0))
  </code></pre>
  <p>does just this, but then I have to drag the formulas down. I want to do it with ArrayFormulas since the number of rows is growing but I can't figure out how. Any suggestions?</p>
  <p>EDIT:
  In the real data there are many columns.</p>