Calculating the mean within a SUBTOTAL function

  • Thread starter Thread starter Daniel Collison
  • Start date Start date
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.
 
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.
 
For the average use:

=SUBTOTAL(1,range)

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