=subtotal(3,a2:A999)
if column A is never empty.

Bob wrote:

Once I have filtered on a given column, is there a way that Excel can
automatically tell me how many rows satisfied the criteria that I filtered
on? Currently, I have to add the COUNTIF function to the bottom of the
column in order to determine the number of rows. Any help would be greatly
appreciated. Thanks.
Bob

--

Dave Peterson