Internet Scholar

The subtotal function ignores any rows that are not included in the result of a filter no matter which function num value you use. Insert subtotals in a list of data in a worksheet insert subtotals make sure that each column in a range of data for which you want to calculate subtotals has a label in the first row contains similar facts in each column and that the range does not include any blank rows or columns.

Excel Tip Need A Quick Way To Calculate Rows Of Related Data By

By default subtotal excludes values in rows hidden by a filter as explained below.

Subtotal function in excel. Use the subtotal function in excel instead of sum count max etc. The subtotal function in excel allows users to create groups and then perform various other excel functions such as sum count average product max etc. Thus the subtotal function in excel helps in analyzing the data provided.

For example the sum function below calculates the total sales. We will start. What subtotal does and how to use it 1.

Use the subtotal function to get a subtotal in a list or database. The subtotal function is designed for columns of data or vertical ranges. Subtotal has the ability to use a variety of functions when subtotaling including average count max and others see table below for a complete list.

Using subtotal with filtered data. To ignore rows hidden by a filter or to ignore manually hidden rows. It is not designed for rows of data or horizontal ranges.

It can be challenging to explain the full extent of what the subtotal function is capable of. Grab your free exercise file here.