Performing a function on visible cells only in a range
 

Is there a way to perform a function (like =sum) on a range but only include
the cells that are visible?

Performing a function on visible cells only in a range
 

From Excel 2033 onwards you can use the SUBTOTAL function, it is clearly
explained in help. In previous versions at least down to 97 you can use
SUBTOTAL when you filter rows but not hide them, from 2003 you can use it on
hidden rows as well

--
Regards,

Peo Sjoblom


"creative" wrote in message
...
Is there a way to perform a function (like =sum) on a range but only
include
the cells that are visible?

Performing a function on visible cells only in a range
 

Great help. Thanks!

"creative" wrote:

Is there a way to perform a function (like =sum) on a range but only include
the cells that are visible?