title: SUMIF/SUMIFS in array formula
body: <p>I have this <strong>Array formula</strong> that Works good:</p>
  
  <pre><code>{=SUM(IF(Range1="L";Range*Range))/SUM(IF(Range1="L";Range))}
  </code></pre>
  
  <p>But if I change <em>SUM(IF</em> to <em>SUMIF</em> doesn't work I don't know why.</p>
  
  <pre><code>{=SUMIF(Range1;"L";Range*Range)/SUMIF(Range1;"L";Range)}
  </code></pre>
  
  <p>And I want to put <em>SUMIFS</em>, because I want to add a new IF in the first formula, like this:</p>
  
  <pre><code>{=SUMIFS(Range*Range;Range1;"L";Range2;"N")/SUMIFS(Range*Range;Range1;"L";Range2;"N")} 
  </code></pre>
  
  <p>What I can do to put two ifs in the array formula?</p>