Hello everyone,

I am using Excel2000. I have a file in which I track
attendance at various activities. My autofilters work
fine, depending on which information I wish to display.
But at the bottom of my list, I display totals for how
many people were present / absent for each day (each of
which is represented in its own column).

Whenever I have an autofilter on for a column in which my
sub-totals DO NOT appear, they are still hidden. As an
example, when a member quits I put a special code in
column A. But this person may have attended some days
before quitting so I must retain him in the file, I
cannot delete his record.

To produce a current list, I use a custom filter in
Column A "not equal" to my special code. This works OK,
but my totals (where the attendance totals for each week
are) do not appear even though there is no active filter
on the columns in question.

Any ideas?