Dave,
Thanks for the suggestion. However, I was hoping that once I clicked the
AutoFilter "arrow" on a given column and selected the criteria to filter on,
Excel would automatically display (maybe in the status area) the number of
rows that met the criteria, thereby avoiding the need to write a formula.
Bob


"Dave Peterson" wrote:

=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