Applying function after filter is applied
 

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?

Applying function after filter is applied
 

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?

Applying function after filter is applied
 

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



"Jacob Skaria" wrote:

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?

Applying function after filter is applied
 

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" wrote in message
...
I type "=Subtotal(MODE(G2:G1796))" and it says I have too few arguments.



"Jacob Skaria" wrote:

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?

Applying function after filter is applied
 

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.

"Ashish Mathur" wrote:

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" wrote in message
...
I type "=Subtotal(MODE(G2:G1796))" and it says I have too few arguments.



"Jacob Skaria" wrote:

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?