Sumproduct of consecutive integers

[jeffrey7]

I would like to take the sum of the cells: A1*10+B1*9+C1*8+D1*7...K1*1. How do I do this?

I tried =sumproduct(A1:K1,10:1). But I guess 10:1 is not a proper list.

Thank you for your help,
Jeffrey

 

[63falcondude]

That doesn't match up. If A1 is multiplied by 10, B1 by 9, etc then J1 (not K1) would be multiplied by 1.

Starting with 11, you can do something like this =SUMPRODUCT(A1:K1,{11,10,9,8,7,6,5,4,3,2,1})

 

[njimack]

=sumproduct(a1:k1,11-column(a1:k1))

 

[63falcondude]

=sumproduct(a1:k1,11-column(a1:k1))

If I am not mistaken, wouldn't it have to be 12-column(...?

Edit: Just realized that I was basing that off of my assumption that A1 has to be multiplied by 11 in order for K1 to be multiplied by 1.

 

[Fennek]

Hi,

try

=MMULT(A1:J1;11-ZEILE(A1:A10))

regards

 

[jeffrey7]

=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

 

[njimack]

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

Don't fully understand, but maybe replace the "11" in my formula with either of the below (after nesting in your INDIRECT function):
MAX(A1:K1)
COLUMNS(A1:K1)