Excel: Sumproduct, input of array and range not working
<p>I am trying to do a sumproduct such as</p>

<pre><code>=SUMPRODUCT(A1:A8,{8,7,6,5,4,3,2,1})
</code></pre>

<p>but it give #VALUE! error,</p>

<p>While it is gives a valid value for </p>

<pre><code>=SUMPRODUCT({8,7,6,5,4,3,2,1},{8,7,6,5,4,3,2,1})
</code></pre>

<p>Or</p>

<pre><code>=SUMPRODUCT(A1:A8,A1:A8)
</code></pre>

<p>According to my understanding it only works if all inputs are of Range or Array type, but not when there are both. Is there any way to make it work?</p>