Yellow cells are calculated ones by Calc macro.
Must be 'Freeze mode' like this( ).
1
average(b1)
average(b1:b2)
3
average(b1:b3)
5
average(b2:b4)
average(b3:b5)
6.7
average(b4:b6)
4.3