hi, ?

Goal: Average a number of cells based on a variable (located in $F$4)
that tells the function how many rows to average [...]
So I'm trying to create a function that will allow me to use the value at $F$4
to determine the "size" of the range
pseduo code is: =AVERAGE(Z5:Z(5+$F$4))
I get about this close: =AVERAGE(INDIRECT("Z" & FUNCTION(current_row)
& ":Z" & FUNCTION(current row)+$F$4))
any and all help is appreciated...

assuming 'F4' includes 'starting' row for the 'sizeable' range...
how about: =average(offset(z5,,,$f$4,))

hth,
hector.