Range summing

B

Blah

hello, when I copy and paste a formula instead of having it go like

SUM(A1:A3)
SUM(A2:A4)


I want it to go
SUM(A1:A3)
SUM(A4:A6)

any easy way to make it happen?
 
B

Bob Phillips

Try

=SUM(INDEX(A:A,ROW(A2)*3-2):INDEX(A:A,ROW(A2)*3))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top