Calculate Summary dynamic name range

[Souris]

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,

 

[Patrick Molloy]

you already have OFFSEt, you can also use RESIZE

 

[Souris]

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,