Apply a simple formula to multiple rows?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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



.

Relevant Pages