# Sumproduct of consecutive integers

#### jeffrey7

##### New Member
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.

Jeffrey

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
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})

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

=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.

Last edited:
Hi,

try

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

regards

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

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

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)

Replies
5
Views
234
Replies
4
Views
165
Replies
2
Views
185
Replies
1
Views
492
Replies
4
Views
217

1,196,359
Messages
6,014,804
Members
441,847
Latest member
hw407

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back