Lists in 2003

A

Al

I use 2003 and make use of the Lists feature which does not seem available
for another user on Excel 2000. Is there anyway that in Excel 2000 you can
add a total, but that when you filter the list by eg Town, it will produce a
total for just those records in the filter please?

Thanks
A
 
D

Dave Peterson

Lists were added in xl2003.

But you could use a formula like:

=subtotal(9,c2:c999)
to get a total of the visible cells (when rows are hidden by an autofilter).

I like to put it row 1, headers in row 2 and details in rows 3-xxxx.

With windows frozen nicely, that subtotal is always visible.
 
P

Patricia Shannon

Has that changed between versions? On my Excel 2003 help, function 9
includes hidden cells. To ignore hidden cells, the function number would
have 100 added to it, so it would be
=subtotal(109,c2:c999)
 
P

Patricia Shannon

Sorry, I didn't read far enough. The 9 vs 109 applies to rows rows hidden by
Format/Row/Hide. Rows that are not included because of a filter ignore, no
matter the function code.
 
Top