| 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 func
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 | |||
| Use value in cell as numeric reference to a row, within a sum func | Excel Programming | |||
| Use value in cell as numeric reference to a row, within a sum | Excel Programming | |||
| increment cell reference whilst reading numeric contents | Excel Programming | |||
| Help pls! Max func to display value of different cell? | Excel Worksheet Functions | |||
| Address func in array reference | Excel Worksheet Functions | |||
Hybrid Mode
