Averaging Data continuously when using Filter function - Need Help

  • Thread starter Thread starter MGray
  • Start date Start date
M

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!
 
=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.
 
=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.
 
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.
 
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.
 
Use the average function number.

=SUBTOTAL(1,xx:xx)

Note that function #9 is sum, not count (#2).
 
Use the average function number.

=SUBTOTAL(1,xx:xx)

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