Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting multiple colums ??? | New Users to Excel | |||
Sum multiple colums of data | Excel Worksheet Functions | |||
VLOOKUP for multiple colums | Excel Worksheet Functions | |||
Using sumproduct to sum multiple colums | Excel Discussion (Misc queries) | |||
Sum mixed colums in multiple worksheets | Excel Worksheet Functions |