Today, I created yet another report in Excel. As usual, I had used the Format as a Table command and then filtered out some data. The next step was to count the number of rows that were still visible. I used the formula =SUBTOTAL(3,A2:A144) and had the required information. This website has a good explanation of the process, along with how to count rows that have been manually hidden (instead of filtered).