=SUBTOTAL(9, ref)

The 9 sums, see help for other values

Regards,
Peter T

"DianaE-HR" wrote in message
...
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?