# multiply each digit by its place number

#### kcmuppet

##### Active Member
Hi,

I've a bunch 12 digit numbers (precededed by a letter) for which I need to multiply each by its place value, and then add them together then apply some more maths to the result to produce a check digiit.

e.g. for X792515389001, I need to multiply the 7 by 2, add it to 9x3, 2x4 etc.

Is there a quicker way to do the multiplying than =sum(mid(A1,2,1)*2,mid(A1,3,1)*3,... etc?

Thanks

### Excel Facts

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

#### Eric W

##### MrExcel MVP
Maybe:

=SUM(MID(A1,{2,3,4,5,6,7,8,9,10,11,12,13},1)*{2,3,4,5,6,7,8,9,10,11,12,13})

Last edited:

Thanks Eric!

You're welcome!

#### Tetra201

##### MrExcel MVP
Not as elegant, but works (to be entered using Ctrl+Shift+Enter):

=SUM(--RIGHT(QUOTIENT(--MID(A1,2,12),10^(ROW(A1:A12)-1))&"")*(14-ROW(A1:A12)))

#### Rick Rothstein

##### MrExcel MVP
Also not as elegant...

=SUMPRODUCT(MID(A1,ROW(2:13),1)*ROW(2:13))

Replies
2
Views
279
Replies
1
Views
225
Replies
3
Views
94
Replies
0
Views
331
Replies
3
Views
419

1,191,187
Messages
5,985,191
Members
439,947
Latest member
fabiannic

### 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