Thanks Duke.

"Duke Carey" wrote:

=sum(offset(g220,0,0,a1,1))

"Danneskjold" wrote:

How do I change a cell range with a reference cell? i.e. cell H220 changes
from =sum(G220:G229) to =sum(G220:G235) by changing cell A1 from 10 to16?