Thread: Calculating the mean within a SUBTOTAL function
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default 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 With QuoteReply With Quote