exclude hidden rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to use Sum to toal a range but exclude any data in hidden rows. That way I could filter another column and run totals for the rows that meet the filter criteria.
 
Take a look at the SUBTOTAL function which will do this. Format would be as
follows:-

=SUBTOTAL(9,A1:A1000) with 9 being the SUM argument (Plenty of others to choose
from as well)

NOTE:- This will only work on rows hidden by a filter such as Autofilter,
UNLESS, you have Excel 2003 which has new additional argument values to allow
you to exclude manually hidden rows from the range as well.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



Bill said:
I would like to use Sum to toal a range but exclude any data in hidden rows.
Click to expand...
That way I could filter another column and run totals for the rows that meet the
filter criteria.
 
Back
Top