title: AVERAGEIF error with arbitrary list of values passed for range parameter
body: <p>I have an average returning expression:  </p>
  
  <pre><code>=AVERAGE((C6*D6);(E6*F6);(G6*H6);(I6*J6);(K6*L6);(M6*N6);(O6*P6);(Q6*R6);(S6*T6);(U6*V6))
  </code></pre>
  
  <p>Since it returns wrong values if any of the elements is zero, I wish to exclude zeros from calculation, by replacing <strong><code>AVERAGE</code></strong> with <strong><code>AVERAGEIF</code></strong> function:  </p>
  
  <pre><code>=AVERAGEIF(((C6*D6);(E6*F6);(G6*H6);(I6*J6);(K6*L6);(M6*N6);(O6*P6);(Q6*R6);(S6*T6);(U6*V6));"&lt;&gt;0")
  </code></pre>
  
  <p>However, Excel does not accept this formula. What is wrong with the formula?</p>
  
  <p>I have also tried with the solution suggested here for non-contigous ranges: <a href="https://colinlegg.wordpress.com/2013/05/04/conditional-average-on-non-contiguous-ranges-using-frequency/" rel="nofollow">https://colinlegg.wordpress.com/2013/05/04/conditional-average-on-non-contiguous-ranges-using-frequency/</a> but with no success.</p>
  
  <pre><code>=SUM(C6*D6;E6*F6;G6*H6;I6*J6;K6*L6;M6*N6;O6*P6;Q6*R6;S6*T6;U6*V6)/INDEX(FREQUENCY((C6*D6;E6*F6;G6*H6;I6*J6;K6*L6;M6*N6;O6*P6;Q6*R6;S6*T6;U6*V6);0);2)
  </code></pre>
  
  <p>I get #VALUE! error.</p>