Number of total rows in the worksheet are 30000 and the. Click Insert Module and paste the following code in the Module window. Apply Filters To See The Calculation on Visible Cells Now that we have the SUBTOTAL function written we can apply filters to multiple columns in the range.
1 open your excel workbook and then click on Visual Basic command under DEVELOPER Tab or just press ALTF11 shortcut.
SUBTOTAL 9 Table1 Sales The SUBTOTAL function was designed to work with filtered data. Click Visible cells only radio button and click OK. How to rank only visible cells in Excel. To come up with an accurate count of the cells we are going to write the formula in the formula space that is in front of the fx function.