| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculate Summary dynamic name range
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, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculate Summary dynamic name range
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dynamic summary report | Excel Worksheet Functions | |||
| Generating a dynamic monthly summary sheet based on weekly data sh | Excel Discussion (Misc queries) | |||
| Calculate Percentiles with dynamic ranges | Excel Worksheet Functions | |||
| dynamic summary table | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Hybrid Mode
