Excel pattern function

[Tugberk]

I want to know the result of this mathematical operation on excell. C8 + C17 + C26 ..... + C(n+9). It must take the number on the every 9th block on same column to the operation. I had never used excel before so I need bit of help. Thanks to every answers and apologize for my English.

[wANKER]

You want to look at the OFFSET function. 

 

https://support.office.com/en-us/article/offset-function-c8de19ae-dd79-4b9b-a14e-b4d906d11b66

 

[Tugberk]

40 minutes ago, wANKER said:

You want to look at the OFFSET function. 

 

https://support.office.com/en-us/article/offset-function-c8de19ae-dd79-4b9b-a14e-b4d906d11b66

 

Can I sum the every nth block in column with offset function? I couldn’t see that how can I do this from that link.

[wANKER]

29 minutes ago, Tugberk said:

Can I sum the every nth block in column with offset function? I couldn’t see that how can I do this from that link.

The function is for getting every nth block 

 

So, OFFSET(C1, 0, 9) would be the cell 9 columns along from C1. 

 

OFFSET(C1, 9, 0) would be the cell 9 rows along from C1

 

=C8+C17+C26 ..... +OFFSET(C1, 9, 0)

 

etc.