If you can pick out a column that always has something in it, you can use:

=subtotal(3,a2:a99)



CliffD wrote:

I have a large spreadsheet containing several hundred rows of data. I want
to filter the list and I want to be able to show the number of records that
match the filter criteria. For example, un-filtered the total number of
records in the list is displayed and, when filtered, the number of records in
the list that match the criteria is displayed.

Can onyone help me please?

Kind regards,

Cliff

--

Dave Peterson