View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bear Black Bear Black is offline
external usenet poster
 
Posts: 4
Default Averaging only visible cells

I know there is a subtotal function that will only add up visible cells when
using filters, but is there a formula that will average only visible cells
when using filters?