Consider summarizing your data with the SUBTOTAL function. SUBTOTAL can be
applied to ignore hidden values.
--
Gary's Student


"DianaE-HR" wrote:

I'm using Microsoft office professional edition 2003.

I have one worksheet containing a database of information for which I have
set up a filter in order to view only certain data. In another worksheet, I
have cells which summarize certain data points contained within the database.
When I filter to look at only select data, I would like the summary cell
formulas to count only the filtered data, not the hidden cells. Is there a
way to do this?