=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