skipping cells

[rafal]

Hi, I imagine this should be an easy one, but I'm a bit slow with these things. I want to sum blocks of five cells in the below format but not sure how i can reproduce that pattern down a column and then across columns. Tried Indirect with row function but that doesn't let me go across columns. Please help. thanks

=sum(C12:C16)
=sum(C17:C21)
=sum(C22:C26)
and so on...

 

[Domenic]

Try...

E12, copied down:

=SUM(OFFSET($C$12,ROWS($E$12:E12)*5-5,0,5))

 

[rafal]

A version of that worked. Thanks you Domenic!!