Sum - offset

[Romos1_excel]

Hello everyone!

I run the rum - offset - row formula for the values in a column to sum every other 10 rows and when I drag the formula down (vertically) it works.
When I drag the formula horizontally it keeps summing only the first 10 rows of the selected area. Any ideas how to make it work when I drag it horizontally ? ?
Picture attached as link

Many thanks!

https://drive.google.com/file/d/1UcoWomLdIxcxsz7vhaDluUa2pdbWMLNy/view?usp=sharing

 

[Fluff]

In B4 like
=SUM(OFFSET($K$5,(COLUMN()-2)*10,0,10,1))

 

[Romos1_excel]

Many Thanks!!!

 

[Fluff]

You're welcome