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