Lists in 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Al - 12 May 2006 14:21 GMT

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

Reply to this Message

Dave Peterson - 12 May 2006 14:47 GMT

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.

> 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
[quoted text clipped - 3 lines]
> Thanks
> A

Signature

Dave Peterson

Reply to this Message

Patricia Shannon - 12 May 2006 19:51 GMT

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)

> Lists were added in xl2003.
>
[quoted text clipped - 14 lines]
> > Thanks
> > A

Reply to this Message

Dave Peterson - 12 May 2006 20:03 GMT

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

> Has that changed between versions? On my Excel 2003 help, function 9
> includes hidden cells. To ignore hidden cells, the function number would
[quoted text clipped - 23 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Patricia Shannon - 12 May 2006 19:55 GMT

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.

> Lists were added in xl2003.
>
[quoted text clipped - 14 lines]
> > Thanks
> > A

Reply to this Message