Thread: Adding the same cell in different worksheets. Can that cell be variable?
View Single Post
  #1   Report Post  
ro
 
Posts: n/a
Default Adding the same cell in different worksheets. Can that cell be variable?
I want to use the same formula =SUM(Sheet1:Sheet2!A1), but i want to be
able to have the column/row as a variable, like
=SUM(OFFSET(C3,1,1,$B$2)).

Basically i don't want to duplicate the same formula n times. And want
to add a variable range.

Can anybody help?

Reply With QuoteReply With Quote