| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to programatically control a 3D-sum?
I have done
SUM(OFFSET(INDIRECT("Sheet"&number&"!E8")..etceter a) to get a sum from a specific sheet"number". It works as expected. Now I want to extend this to get the sum of all sheets from sheet"0" to sheet"number". However I try it seems that INDIRECT does not like a ":" and gives me #REFERENCE. Why can't I simply do SUM(OFFSET(INDIRECT("Sheet0:Sheet"&number&"!E8").. etcetera) and how should I actually solve this task. Best regards / Ake |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
| API for MS Chart Control | Charts and Charting in Excel | |||
| Variable control tip text | Excel Discussion (Misc queries) | |||
| calendar control - formatting | Excel Discussion (Misc queries) | |||
| Copying list-box control | Excel Discussion (Misc queries) | |||
Threaded Mode
