| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use value in cell as numeric reference to a row, within a sum
The only note I would add is that Indirect is a volatile function
(recalculate every time a calculation is run whether it needs to or not) so it can slow XL down if you add hundreds (or thousands) of them. -- HTH... Jim Thomlinson "cspr" wrote: Jim, that's brilliant; thank you so much for helping me with this! Your formula enables me to do exactly what I wanted to do. "cspr" wrote: I would like to be able to use a value in a cell as the numeric reference to a row in another column, to which to sum values in that column. Eg. If A5 = 7, sum values in cells D3 to D7. If A5 = 13, sum values in cells D3 to D13. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TO DELETE ONLY NUMERIC VALUES IN A CHARACTER AND NUMERIC CELL IN | Excel Discussion (Misc queries) | |||
| How do I copy numeric section of cell from alpha-numeric cell | Excel Worksheet Functions | |||
| Reference Numeric Variable in Macro | Excel Programming | |||
| only extract numeric value from alpha numeric cell | Excel Discussion (Misc queries) | |||
| increment cell reference whilst reading numeric contents | Excel Programming | |||
Hybrid Mode
