Can I make hidden cells inactive so formulas ignore their value?
 

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?

Can I make hidden cells inactive so formulas ignore their value?
 

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?

Can I make hidden cells inactive so formulas ignore their value?
 

=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?