I found a method to do this on the web. Basically, go to the bottom of your filtered sheet and enter this function into an empty cell:
Note: when I did the above I got a smiley face! The function is:
=SUBTOTAL(3,DcolonD)-1 (that is the cap letter "D" a colon and then another "D" after that (no spaces)
Then click off to another cell and it will automatically count the number of filtered rows. This also keeps working if you add or delete rows.
To read the complete article about how to do this go here:
I tried this.. it works!
I know there is a function in Excel where it counts the records you have filtered and puts the count in the status bar at the bottom of the screen. On some machines this is turned on and some it is turned off. However, after an extensive search, I cannot find where to turn this function on. Can anyone help please?