Applying function after filter is applied

[lacklustre]

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?

 

[Jacob Skaria]

Take a look at the function

=SUBTOTAL()

If this post helps click Yes

 

[lacklustre]

I type "=Subtotal(MODE(G2:G1796))" and it says I have too few arguments.

 

[Ashish Mathur]

Hi,

If you read up on SUBTOTAL in the Help menu, you will see that you have to
specify a function argument. 1 for average, 2 for count and so on. Please
go through the list and use the appropriate function argument

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[lacklustre]

Don't see one for mode, which is important cause I'm sorting through a few
thousand lines. Also need to know how to do this for MODE function on words.