Using Count function when the data is filtered

[rampure]

Hi,

I have a huge data about 5000 rows.
I have the filter on.
Now I want to use the count and sum functions just for the filtered data and when I change the filter condition, the function should relect the change too.

Thanks for your response in advance and I really appreciate the time.
Smitha

 

[SkipVought]

Hi,

Take a look at the SUBTOTAL function.

Skip,

_[red][/red]

 

[rampure]

Thank you Skip.