Calculating the mean within a SUBTOTAL function

[Daniel Collison]

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

 

[Michael Arch]

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.

 

[Sean Timmons]

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.

 

[T. Valko]

For the average use:

=SUBTOTAL(1,range)

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