=sumproduct(a1:k1,11-column(a1:k1))
=sumproduct(a1:k1,11-column(a1:k1))
Thanks for your answer.
I use an indirect() reference to generate my a1:k1 array, so it could be b20:z20 or ab546:cx546 depending on the inputs in other cells.
Whatever the array is, I would like to generate the sumproduct so that the first value of the array (a1 or a20 or ab546) is multiplied by the highest position in the series (11, 25, 75), and the last value (k1, z20, ab546) is multiplied by 1.
Is this doable?
Jeffrey