Thread
:
Apply a simple formula to multiple rows?
View Single Post
#
2
Don Guillett
Posts: n/a
Have a look at HELP index for INDIRECT
--
Don Guillett
SalesAid Software
"RedFox" wrote in message
link.net...
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
Reply With Quote