Thread: average filtered values
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default average filtered values
Hi,

=SUBTOTAL(101,E2:E30)

wher e2 to E30 id the un-filtered range

Mike

"Gaurav" wrote:

is it possible to average the filtered values only?



Reply With QuoteReply With Quote