Where is this data?

--
Biff
Microsoft Excel MVP


"Picman" wrote in message
...
The problem is that i'm totaling the number of values that fall between
curtain ranges, how many are between 100 to 149, and ,150 to 199, 200 to
249.....etc.

"Brotha Lee" wrote:

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.