Exact formula I am using is:-

=OFFSET(Summary!$BE$16,,(ROWS($5:5)-1)*3,,)

Returns a "0"

Thanks