How to replace Offset() with non-volatile formulas?

Hi,

I have a formula

=Sum(Offset(A100,,,B1))
where the height in B1 is a user input.

Is there any efficient way to change the Offset part with non-volatile formulas?
(I have tens of thousands of these so I need them to be non-volatile to speed up.)

Thanks.