Sum a variable number of cells

Originally Posted by lhmome

Awesome! Never realized offset had the width/height ability.

Thanks.

True but it's also Volatile so avoid it if you can, normally when using OFFSET an INDEX approach is equally viable and non-Volatile, using your example:

A2: =SUM(A1:INDEX(A1:$IV1,$L2))
copy across ... apply to row 6 in the same manner