| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating the mean within a SUBTOTAL function
Has anyone experience calculating a mean when using a subtotal function?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| subtotal function | New Users to Excel | |||
| Using Subtotal function | Excel Discussion (Misc queries) | |||
| Subtotal function | Excel Worksheet Functions | |||
| Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
| How do I nesting subtotal function within average function in Exc | Excel Worksheet Functions | |||
Linear Mode
