Display Filter Counts/Subtotals in Excel

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"

No comments:

Post a Comment