This is actually a very good question. What's the good of being able to
filter is we can't process the filtered data. See SUBTOTAL in Excel Help.
--
Gary''s Student - gsnu200789


"RHino56" wrote:

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