Take a look at the function

=SUBTOTAL()

If this post helps click Yes
---------------
Jacob Skaria


"lacklustre" wrote:

I need to use functions like mean, median, mode, standard deviation, etc,
after I apply different filters to a sheet. Whenever I try to use functions
it includes the values excluded by the filter (as if event though the cells
were hidden, they were still used in the calculations). How do I apply a
filter then use a function like mean median and mode to only work on the
values visible?