That is as you filter rows in a table with a Total row youll see the calculations update automatically to respect the filter. Use the SUBTOTAL function in Excel instead of SUM COUNT MAX etc. If you want to create a SUBTOTAL formula in Microsoft Excel youll need to follow these steps.
Select COUNT from the drop-down menu and Size from the Add subtotal field to After that uncheck the.
For example the SUM function below calculates the total sales. Use the SUBTOTAL function in Excel instead of SUM COUNT MAX etc. When you insert subtotals. SUBTOTAL function_num ref1 ref2.