How to define a range of cells, by two variables?

[Skipperron]

My apology if this questions has been asnwered before (or if this is something trivial):

The question is, how to define a range of cells, by two variables?

Example:

I want to calculate the average of the values in the cells AVG = AVERAGE(A5:A9), based on the two values (5 and 9) listed as "Start Column" and "End Column":


When I change the value of "End Column" to 13, the result should be AVG = AVERAGE(A5:A13)


Thanks,

Ron

[Colin Legg]

Welcome to the forum.

These sorts of variations will do the trick, where StartValue is 5 and EndValue is 13.

=AVERAGE(INDEX(A:A,StartValue):INDEX(A:A,EndValue))

=AVERAGE(INDIRECT("A"&StartValue&":A"&EndValue))