For worksheet functions that support missing values, you could write an array
formula using a VBA function like IsVisible
http://groups.google.com/group/micro...39e348e139e1bc
to select only the visible data.

Jerry

"Fred Zack" wrote:

Is there any way to do statistics on ONLY the data SHOWING in a filtered
spreadsheet and not the entire file (hidden data and all). I dont mean using
the SUBTOTAL function that only allows those specific ten or so I want to do
Regression, T-tests, etc.

In fact what is the point of filtering data if statistics applied to it are
going to be applied to all the data?