| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
variable reference ranges
Hi - I want to write a formulae where the reference range is variable. For
example, =average(c3:c(3+variable number)). I would really like to do this by referencing another cell for the variable number. Is this possible, I have tried a number of approaches but am getting no joy. Thanks SC. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
variable reference ranges
=AVERAGE(C3:INDEX(C:C, 3+C1))
where C1 contains your variable number. "SC" wrote: Hi - I want to write a formulae where the reference range is variable. For example, =average(c3:c(3+variable number)). I would really like to do this by referencing another cell for the variable number. Is this possible, I have tried a number of approaches but am getting no joy. Thanks SC. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
variable reference ranges
Awesome!
"JMB" wrote: =AVERAGE(C3:INDEX(C:C, 3+C1)) where C1 contains your variable number. "SC" wrote: Hi - I want to write a formulae where the reference range is variable. For example, =average(c3:c(3+variable number)). I would really like to do this by referencing another cell for the variable number. Is this possible, I have tried a number of approaches but am getting no joy. Thanks SC. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting Variable Data Ranges | Excel Discussion (Misc queries) | |||
| Sorts on variable ranges | Excel Worksheet Functions | |||
| Variable ranges | Excel Worksheet Functions | |||
| Sum Variable Ranges | Excel Worksheet Functions | |||
| Variable Print Ranges | Excel Discussion (Misc queries) | |||
Linear Mode
