AutoFilter and row count

B

Bob

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
 
D

Dave Peterson

=subtotal(3,a2:A999)
if column A is never empty.
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
Click to expand...
 
B

Bob

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
 
B

Bob

Dave,
Thanks for the info! I went to Debra Dalgleish's site and clicked on the
two Microsoft Knowledge Base links. What I learned is if I set Calculation
to Manual, I then get a count of the filtered rows in the Status bar.
Thanks again,
Bob
 
D

Dave Peterson

Don't forget to toggle it back on before you trust any formulas.
Dave,
Thanks for the info! I went to Debra Dalgleish's site and clicked on the
two Microsoft Knowledge Base links. What I learned is if I set Calculation
to Manual, I then get a count of the filtered rows in the Status bar.
Thanks again,
Bob
Click to expand...
 
Top