Calculating the mean within a SUBTOTAL function
 

Has anyone experience calculating a mean when using a subtotal function?

Calculating the mean within a SUBTOTAL function
 

The subtotal function does not support the mean only the following functions:
1 101 AVERAGE
2 102 COUNT
3 103 COUNTA
4 104 MAX
5 105 MIN
6 106 PRODUCT
7 107 STDEV
8 108 STDEVP
9 109 SUM
10 110 VAR
11 111 VARP
--
If this posting was helpful, please click on the Yes button on the bottom
right of this window.
Regards,

Michael Arch.




"Daniel Collison" wrote:

Has anyone experience calculating a mean when using a subtotal function?

Calculating the mean within a SUBTOTAL function
 

what kind of help are you looking for?

AVERAGE provides the mean, so you would use 1 as your function number if you
would like to include hidden values or 101 if you want to ignore hidden
values.

"Daniel Collison" wrote:

Has anyone experience calculating a mean when using a subtotal function?

Calculating the mean within a SUBTOTAL function
 

For the average use:

=SUBTOTAL(1,range)

If by "mean", you mean something more statistically complex then I'm not the
person to ask!

--
Biff
Microsoft Excel MVP


"Daniel Collison" wrote in
message ...
Has anyone experience calculating a mean when using a subtotal function?