Picman,

Use the subtotal function. it should be something like this
= subtotal(102,A:A) to count all values in column A.

If filtered it will ignore the hidden values

"Picman" wrote:

I have a list of value that i've built formulas to count the number of
occurrences of values that fall into curtain ranges. Now I what to filter the
data and do the calculations on the filtered values only, and not include the
other values.