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