Ask Your Question

Is there an easy way to define steps in a range in Calc?

asked 2016-02-17 11:48:25 +0200

What I want is AVERAGE(B2, B9, B16, B23 .. B989, B996). I tried it this way: AVERAGE(B2:7:B1000). The result was a Err:502. Is there an easy way to only get every seventh value?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-02-17 15:54:59 +0200

I have a Solution:

But I am interested if there is a better one.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-02-17 11:48:25 +0200

Seen: 72 times

Last updated: Feb 17 '16