Filters
 

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

Hi
try
=SUBTOTAL(3,A1:A100)

"Dave" wrote:

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

=subtotal(3,B2:B200)

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

--
Regards,
Tom Ogilvy



"Dave" wrote in message
...
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

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.

"Tom Ogilvy" wrote:

=subtotal(3,B2:B200)

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

--
Regards,
Tom Ogilvy



"Dave" wrote in message
...
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