exclude hidden rows

[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.

 

[Ken Wright]

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
----------------------------------------------------------------------------

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.