calculation multiple row & colums
 

I placed i a cell
=M6*G6*J6+M7*J7*G7+M8*J8*G8+M9*J9*G9+M10*J10*G10+M 11*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

calculation multiple row & colums
 

Hi,

=SUMPRODUCT(G6:G8,J6:J8,M6:M8)

Regards,

Jan Karel Pieterse
Excel TA/MVP

-----Original Message-----
I placed i a cell
=M6*G6*J6+M7*J7*G7+M8*J8*G8+M9*J9*G9+M10*J10*G10+ M11*J11*G
1
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

.

calculation multiple row & colums
 

Paul,

Try the following:

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"paul" wrote in message
...
I placed i a cell
=M6*G6*J6+M7*J7*G7+M8*J8*G8+M9*J9*G9+M10*J10*G10+M 11*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