Ask Your Question
0

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
0

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

I have a Solution:
=SUMPRODUCT(B2:B1000,MOD(ROW(B2:B1000),7)=2)/SUMPRODUCT(MOD(ROW(B2:B1000),7)=2)

But I am interested if there is a better one.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 72 times

Last updated: Feb 17 '16