| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using range with INDIRECT and ROW()
I am setting up a spreadsheet that with add columns in a row, but need
it to be applicable to various rows, I hacked this formula together so far: =SUM(INDIRECT("A"&ROW()), INDIRECT("B"&ROW()), INDIRECT("C"&ROW()), INDIRECT("D"&ROW()), INDIRECT("E"&ROW())) Anyone have a suggestion how to improve this formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| Using Indirect to set a range | Excel Worksheet Functions | |||
| using indirect to sum range | Excel Worksheet Functions | |||
| Indirect Range | Excel Worksheet Functions | |||
| Indirect range in SUMPRODUCT? | Excel Discussion (Misc queries) | |||
Threaded Mode
