Calculate Summary dynamic name range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Name range like following

MyName
OFFSET($B$12,0,0, COUNTA($B$12:$B$65000), SHEETS("MYSHEETS").RANGE($D$12))


Because the name range is changed base on ($B$12:$B$65000),
SHEETS("MYSHEETS").RANGE($D$12) values.

I need calculate the summary like average, total per row and per column.

Are there any way to access dynamic range relative cells?

Like MyName.cells(1,1) can reference cell "MYSHEET"!$B$12.

Thanks millions for any information,
 
Thanks for the information,
Since the name range is dynamic, are there any way to calculate the total
and average of one row or column.

Thanks again,
 
Back
Top