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!
--
MGray

=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.

--
Biff
Microsoft Excel MVP


"MGray" wrote in message
...
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!
--
MGray

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.

"MGray" wrote:

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!
--
MGray

Use the average function number.

=SUBTOTAL(1,xx:xx)

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

Luke M
*Remember to click "yes" if this post helped you!*


"MGray" wrote:

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!
--
MGray