Formula to increase cell reference

[kamoorthy]

I am trying to add numbers from first sheet data to second sheet data.

I have to reference to another sheet a fixed increase of moving 8 rows across. What would be the formula for it?

For Example:


=SUM(SS!C2:SS!MM2)
=SUM(SS!C10:SS!MM10)
=SUM(SS!C18:SS!MM18)
=SUM(SS!C26:SS!MM26)



What would be the formula for the subsequent cells.

Thanks in advance.

 

[Jonmo1]

try

=SUM(OFFSET(SS!$C$2:$MM$2,(ROWS($1:1)-1)*8,0))

 

[VBA Geek]

=sum(index(ss!c:c,(rows(a$1:a1)-1)*8+2):index(ss!mm:mm,(rows(a$1:a1)-1)*8+2))

 

[kamoorthy]

Thanks a ton