Thread: How do I change a cell range with a reference cell?
View Single Post
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default
=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?
Reply With QuoteReply With Quote