View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default Subtotal Averages

Are there any hidden rows in the SUBTOTAL(1... function's range? I
found this in the Help:
"But, hiding a row in a subtotal of a vertical range does affect the
subtotal."