Applying function after filter is applied


L

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?
 
Ad

Advertisements

A

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
 
Ad

Advertisements

L

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top