You can use the SUBTOTAL formula to display how many results (or “records”) are returned from applying a filter to your Excel spreadsheet.
Let’s say that you have a long list of data and have applied a filter to a column, the status bar at the bottom will show you how many results are showing.
Well you can also use the subtotal formula to identify this number.
=subtotal(3,A2..A49) – Do not include your header row in the range!
Finally you can even include this total in a tweet!
24 errors found on report; click here to view
=SUBTOTAL(3,A2:A49) & " errors found on report; click here to view"