View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RHino56 RHino56 is offline
external usenet poster
 
Posts: 3
Default sum of visable cells in filtered range

I have a sheet to track hours of employees for a project. I used the auto-sum
to total the hours range of cells. I would like to format a separate
calculation to total only those cells displayed in a filtered range. As I
change the filter, the total should again include on the new visable cells in
the range. Help!
--
RHino56