See post 13 above and try

=OFFSET(Summary!$BE$16,,(ROWS($5:5)-1)*3,,) but it returns a zero. What am I doing wrong please?