Darrell

Check out the SUBTOTAL Function in Excel Help.

NOT DataSubTotal but the Function.


Gord Dibben Excel MVP

On Thu, 21 Jul 2005 15:56:01 -0700, "Darrell"
wrote:

When I filter a column, how do I exclude from any function the data in hidden
cells?