View Single Post
  #1   Report Post  
RedFox
 
Posts: n/a
Default Apply a simple formula to multiple rows?

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