Filters

[Dave]

How can I set up the spreadsheet to automatically count and show the number
of records that have been returned by an advanced filter?
Dave

 

[Frank Kabel]

Hi
try
=SUBTOTAL(3,A1:A100)

 

[Tom Ogilvy]

=subtotal(3,B2:B200)

if there will always be a value in column B for each record.

 

[Dave]

This function works, but fortunately it does not require a value in each
record. I tried using the COUNTA function by itself and it counted all the
records in the full list irrespective of the filtering, whereas the SUBTOTAL
function appears to take into account the reduction in the number of records
showing due to the filtering. Thanks for your help.