Hello,

In column C I try to calculate an average from data in column B and the number of cells in column B to be calculated is defined by a variable Time.
To clarify, Time is a variable number that will indicate the first number of rows to be calculated. Column B will not start at row 2 but rather at a unspecified row (approx between say row 20 and 30).
Example:
Time=5
column B: row 21 as first row with a number
in column C: looking in row 25 for average of 5 first values of column B (row 21 to 25)

This value is calculated only once (so no rolling value). I'm looking for a generic formula.
Thanks for your help.