| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Define Range with an offset
I have a column of numbers which I want to sum the numbers between two cells
which have a formula like sum(XX: offset(activecell,-1,0). The problem I am having is finding or defining the cell(XX). Sometimes there 1, 2, 3, 4 or sometimes even 7 numbers up to cell(XX). How do I find cell(XX). I hope this is not too sketchy. TIA Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
| Setting source data range with Charts | Charts and Charting in Excel | |||
| Vlookup of parts of a word in a range of Data | Excel Discussion (Misc queries) | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
| HTML_Control Range name | Excel Discussion (Misc queries) | |||
Threaded Mode
