Shorter formula with same output

[Wabito Express]

Hi guys, nice to meet you

i am really common in excel environment but i hope through this forum i could gain more knowledge about Excel, ok here my first question :
is there any shorter formula that have a same ouput with following formulas :

c1=(a1*b1)+(a2*b2)+(a3*b3)+(a4*b4)+.....+(a10*b10)

i really appreciate for your help and assistance guys

[Haseeb Avarakkan]

Hi, use SUMPRODUCT

=SUMPRODUCT(A1:A10,B1:B10)

[Søren Larsen]

Try using this:

=SUMPRODUCT(A1:A10;B1:B10)

It is likely that the semicolons should be ordinary commas. (I have a European version of Excel)

[Wabito Express]

thanks for the reply

that formula really help me out with the problem, thanks guys ^^,

btw if i put that formula into B1 (B1 --> =sumproduct(a2;a10,b2;b10)) then i copy it to next coloumn C2, why the formula was changed (C2 --> =sumproduct(b2;b10,c2;c10))? is there any way to kept the "a2;a10" or "array1;array2" as the multipaction value ??

im sorry for my bad english guys

[Haseeb Avarakkan]

Use,

=SUMPRODUCT($A1:$A10,B1:B10)

Changes because of it was on relative reference. See this link

[Wabito Express]

thanks Haseeb A for the help

now everything running as i expected ^^