Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect and Sum across Multiple Sheets
I have been hunting for a way to do this for a few hours now. It
appears that this combination is only good on 2d ranges, not 3d. But I'll ask again anyway. I have a formula that works fine =SUM(Start:End!F181) But what I want to do is change the 181 value (or possibly the F181) to a variable that will be stored in a cell on the same sheet as this formula. (which is a totals page) Is this possible? TIA Guy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indirect a range that spans multiple sheets | Excel Worksheet Functions | |||
Indirect - Multiple Sheets/Cells | Excel Worksheet Functions | |||
INDIRECT for range of sheets | Excel Worksheet Functions | |||
INDIRECT and multiple sheets | Excel Worksheet Functions | |||
Sum Indirect function through multiple sheets | Excel Discussion (Misc queries) |