How can I count items in a filtered list?

=subtotal(2,a1:a1000)

"Counting filtered data." <Counting filtered
[email protected]> wrote in message
news:[email protected]...
>I have an excel spread sheet table that I filter. I would like to be able
>to
> count the number of cells in the filtered data. Anyone know how to do
> this?
> CountA returns the number of cells in the unfiltered data.
> Tom

=subtotal(2,a1:a1000)

"Counting filtered data." <Counting filtered
[email protected]> wrote in message
news:[email protected]...
>I have an excel spread sheet table that I filter. I would like to be able
>to
> count the number of cells in the filtered data. Anyone know how to do
> this?
> CountA returns the number of cells in the unfiltered data.
> Tom

=subtotal(2,a1:a1000)

"Counting filtered data." <Counting filtered
[email protected]> wrote in message
news:[email protected]...
>I have an excel spread sheet table that I filter. I would like to be able
>to
> count the number of cells in the filtered data. Anyone know how to do
> this?
> CountA returns the number of cells in the unfiltered data.
> Tom

I have an excel spread sheet table that I filter. I would like to be able to
count the number of cells in the filtered data. Anyone know how to do this?
CountA returns the number of cells in the unfiltered data.
Tom

=subtotal(2,a1:a1000)

"Counting filtered data." <Counting filtered
[email protected]> wrote in message
news:[email protected]...
>I have an excel spread sheet table that I filter. I would like to be able
>to
> count the number of cells in the filtered data. Anyone know how to do
> this?
> CountA returns the number of cells in the unfiltered data.
> Tom