| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill an Indirect Statement
I need to add Indirect to 5000 rows of formula. So, with the following
formula, how can I get it to fill with the correct cell references(T2 becomes T3 and Z2 becomes Z3 and so on down the column)? =SUM(INDIRECT("Allocate!T2")+INDIRECT("Allocate!Z2 ")) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Indirect ref in array formulas | Excel Worksheet Functions | |||
| Excel printing problem - won't print cell under a "fill effect" bo | Excel Discussion (Misc queries) | |||
| Fill Color Red | Excel Discussion (Misc queries) | |||
| Fill colour red | Excel Discussion (Misc queries) | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Threaded Mode
