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

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.

Al wrote:
>
> 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

--

Dave Peterson

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)

"Dave Peterson" wrote:

> 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.
>
> Al wrote:
> >
> > 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
>
> --
>
> Dave Peterson
>

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.

"Dave Peterson" wrote:

> 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.
>
> Al wrote:
> >
> > 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
>
> --
>
> Dave Peterson
>

xl2003 was the first to have those 100 series, too.

Patricia Shannon wrote:
>
> 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)
>
> "Dave Peterson" wrote:
>
> > 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.
> >
> > Al wrote:
> > >
> > > 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
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson