ExcelBanter - How do I change a cell range with a reference cell?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I change a cell range with a reference cell? (https://www.excelbanter.com/excel-discussion-misc-queries/39950-how-do-i-change-cell-range-reference-cell.html)

Danneskjold

How do I change a cell range with a reference cell?

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?

Duke Carey

=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?

Danneskjold

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?

All times are GMT +1. The time now is 10:43 AM.