Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello Esteemed Gurus :-)
I have a formula for rows in the form =A10*DJ+E10*HJ+I10*LJ+M10*PJ+Q10*TJ The J is a variable that represents the row and there are over 100 rows, so it would be extremely boring to have to input this formula on every line. I'm exhausted after doing just 10 ;-) X(J)=A10*D(J)+E10*H(J)+I10*L(J)+M10*P(J)+Q10*T(J), J= Jstart, Jend ???, where X is the column of results??? Tried =SUM(A10*D+E10*H+I10*L+H10*P+Q10*T) on col X but no success. Any shortcuts? TIA rf |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert rows, keep a formula? | Excel Worksheet Functions | |||
how to create a multiple conditional formula | Excel Discussion (Misc queries) | |||
can you hide rows with a formula? | Excel Discussion (Misc queries) | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
Multiple rows of data on a single axis (charting) | Charts and Charting in Excel |