Thanks, Gary's Student. The final value is what I was looking for but, is
there any way to have this subtotal in a dedicated cell location instead of
adding it to the bottom of the list? Now the subtotal is also added into the
auto-sum value for the column. I am using MS Ofc 2003 SP3.
RHino56


"Gary''s Student" wrote:

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