Averaging Data continuously when using Filter function - Need Help

[MGray]

Need formula to average column of numbers as is, and as they will be as I
sort by using the Filter.


I can do this for total counts using the =Subtotal(9,xx:xx) function but
can't figure out how to do it for averages.

Much appreciation!

 

[T. Valko]

=Subtotal(9,xx:xx)

Replace the 9 with a 1 to get the average. See help on the SUBTOTAL function
for the list of index numbers and their meaning.

 

[T. Valko]

=Subtotal(9,xx:xx)

Replace the 9 with a 1 to get the average. See help on the SUBTOTAL function
for the list of index numbers and their meaning.

 

[Sheeloo]

Use 1 (to include hidden values) or 101 (to exclude hidden values) instead of
9 to get average...
Filtered values are always excluded.

Look in Help for subtotal for details.

 

[Sheeloo]

Use 1 (to include hidden values) or 101 (to exclude hidden values) instead of
9 to get average...
Filtered values are always excluded.

Look in Help for subtotal for details.

 

[Luke M]

Use the average function number.

=SUBTOTAL(1,xx:xx)

Note that function #9 is sum, not count (#2).

 

[Luke M]

Use the average function number.

=SUBTOTAL(1,xx:xx)

Note that function #9 is sum, not count (#2).