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