How to get dynamic range average in Google SpreadSheet?

Question

excel

There is a column with data, some of which are zero:
123
111
...
321
333
0
0
...
0
I get the average of them using the formula =AVERAGEIF(F3:F33; ">0").
Is it possible to get the average not from all values ​​greater than zero, but from the last ten values ​​from those greater than zero. Zeros are guaranteed to come after non-zeros.

Answer 1

=AVERAGE(INDIRECT(ADDRESS(MATCH(0, F:F,0)-1.6) & ":" & ADDRESS(MATCH(0, F:F,0)-10.6)))

Answer 2

=AVERAGEIF(full range of values;"condition";range to be checked). for example:=AVERAGEIF(A1:A8; ">0";A4:A8)