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?