Calculate Summary dynamic name range

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,

you already have OFFSEt, you can also use RESIZE

"Souris" wrote:

> 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,

"Patrick Molloy" wrote:

> you already have OFFSEt, you can also use RESIZE
>
> "Souris" wrote:
>
> > 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,
> >
> >
> >