How do Excel tables use subtotal?

How do Excel tables use subtotal?

Excel table

Excel table subtotal Using the following steps:

The SUBTOTAL function in Excel is a summary function that can include the use of multiple functions such as summation, totals, averages, and so on. The advantage of the SUBTOTAL function is that you can ignore hidden cells, support three-dimensional operations, and range array references.

The SUBTOTAL function is to return subtotals in a list or database.

The SUBTOTAL function is the Almighty King, which can be averaged, counted, Max-min, multiplied, standard deviation, sum, and variance of the data.

Of course, these features Excel also has a special function to complete, to learn is the SUBTOTAL function can complete some other functions difficult to complete the methods and techniques, first look at the Excel Help file in the SUBTOTAL function explanation.

SUBTOTAL function Syntax: SUBTOTAL (function_num, REF1, Ref2, ...)

The first parameter: Function_num is a number between 1 and 11 (containing hidden values) or 101 to 111 (ignoring hidden values), specifying what function to use in the list for subtotal calculations.

Second parameter: REF1, ref2 1 to 254 ranges or references to be calculated for subtotals.

The key to the use of the SUBTOTAL function is the selection of the first parameter.

The subtotal 1th parameter code corresponds to the function table as shown in the following figure:

Excel table

The function of subtotal function is more comprehensive, it has its uniqueness and limitation compared with other specialized functions:

1: You can ignore the hidden cells, the results of the visible cells operation, often with the filter used, but only to hide the row is valid, the column is hidden invalid; the difference between the first parameter and the two parameter is hidden: the effect of the filter is the same.

2: Three-dimensional operation is supported.

3: Only references to cell ranges are supported

4: The first parameter supports array parameters.