View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael Arch Michael Arch is offline
external usenet poster
 
Posts: 32
Default 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?