View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
goody goody is offline
external usenet poster
 
Posts: 14
Default Subtotal across a row

I understand that subtotal 101 calculates an average of cells in a column
without counting the hidden rows. Is there a comparable method to calculate
the average of cells in a row without counting the hidden column values?

Goody