Getting a Count when using Autofilter (2003)

Topic

New Reply

Greetings,

I have a need to display the count of information when using the autofilter. What I would like to do is, display on the spreadsheet the count of items listed AFTER I have selected something from the dropdown in a filter selection list.

I tried using the count function, but that only counted the entire list of items, not the displayed items.

Any Ideas?

Thanks,
Brad

Reply | Quote

Replies

You can use the SUBTOTAL function for this, with 3 (count of arguments) or 2 (count of numbers) as first argument, e.g.

=SUBTOTAL(3,A2:A100)

The formula will be recalculated automatically when you apply a filter.

Reply | Quote

Very slick…..

thanks,
Brad

Reply | Quote

(Edited by Jezza on 21-Feb-08 17:29. Opps I assumed Sum not CountA, changed to reflect this)

Hi Brad

You can use the Subtotal Function

In the last row of your data type this formula

=SUBTOTAL(3,B2:B100)

The 3 depicts the CountA of the cells visible

Reply | Quote