View Single Post
  #5   Report Post  
Max
 
Posts: n/a
Default

One way, if I've read your post correctly ..

Assuming the variable "J" is starting on the same row 10,
and extending down by 100 continuous rows

Think you could try in say, X10, either:

=SUM(A10*OFFSET(A10,,3,100),E10*OFFSET(E10,,3,100) ,I10*OFFSET(I10,,3,100),M1
0*OFFSET(M10,,3,100),Q10*OFFSET(Q10,,3,100))

(Array-enter the formula above, i.e. press CTRL+SHIFT+ENTER)

Or the slightly longer, but non-array entered SUMPRODUCT version

=SUMPRODUCT(A10*OFFSET(A10,,3,100)+E10*OFFSET(E10, ,3,100)+I10*OFFSET(I10,,3,
100)+M10*OFFSET(M10,,3,100)+Q10*OFFSET(Q10,,3,100) )

(normal ENTER the formula above will do)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"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