If I understand you correctly, a formula like:

=AVERAGE(B2:B11)

will work correctly regardless of the number of filled cells in the
range. Such a formula can be placed anywhere below B11 or above B2 (if
you have a limited set of formulas you can consider placing them above
the data).

Does this help?

Kostis Vezerides