Thread
:
calculation multiple row & colums
View Single Post
#
3
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
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
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson