Is there a way to calculate values in an unlimited range of cells in a
column WITHOUT also calculating values that had previously been filtered
AGAINST?

For instance, I've set up a group of calculating cells to keep track of
the number of times that the the string values "Ad in other paper", "Ad in
community newspaper" and "Ad in a state newspaper" appear in a table which
will grow as new records are added (via a dynamically linked database in
access).

Presently, if I use (B:B), my calculating cells count not only the visible
records, but also the records I hid with a filter on another table that
excluded all values that did not = "Antarctica".

Sorry it's so complex and I am so poor at explaining these things!

Regards


yadang


--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/