function disregard hidden rows?

G

Geo

is there a way to force a function to NOT include the
hidden rows when calculating functions such as slope and
intercept?

I know SUBTOTAL works this way, but I'd really like to be
able to use some of the other stat functions as well.
 
Top