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!