calculation multiple row & 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

 

[Jan Karel Pieterse]

Hi,

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

Regards,

Jan Karel Pieterse
Excel TA/MVP

 

[Chip Pearson]

Paul,

Try the following:

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)