caclulate multiple rows & colums

[paul]

I placed i a cell
=M6*G6*J6+M7*J7*G7+M8*J8*G8+M9*J9*G9+M10*J10*G10+M11*J11*G1
1+M12*J12*G12..... till row 52


above should explain what i want
but instead of typeing everything I want this sequential
formula been automated

in basic it could be like
for x=6 to 52
y=y+(Mx*Gx*Jx)
next x
cell M1=y


is this something like this possible in excel
maybe i have to use an array? but this not well known to me

thx

paul

 

[Paul]

I placed i a cell
=M6*G6*J6+M7*J7*G7+M8*J8*G8+M9*J9*G9+M10*J10*G10+M11*J11*G1
1+M12*J12*G12..... till row 52


above should explain what i want
but instead of typeing everything I want this sequential
formula been automated

in basic it could be like
for x=6 to 52
y=y+(Mx*Gx*Jx)
next x
cell M1=y


is this something like this possible in excel
maybe i have to use an array? but this not well known to me

thx

paul

In Excel, you can write this as an array formula:
=SUM(M6:M52*G6:G52*J6:J52)
An array formula has to be entered using CTRL+SHIFT+ENTER rather than just
ENTER.

 

[Ken Wright]

=SUMPRODUCT(M6:M52*G6:G52*J6:J52)

or

=SUMPRODUCT(M6:M52,G6:G52,J6:J52)