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?
|