Excel2010

The usage steps are as follows:

The subtotal function in Excel 2010 is a summary function, which can include the use of multiple functions such as summation, summary, average, etc. The advantages of the subtotal function are that it can ignore hidden cells, support three-dimensional operations and area array references.

The subtotal function returns the subtotal summary in a list or database.

The subtotal function can be said to be the all-rounder. It can calculate the average, count, maximum and minimum, multiplication, standard deviation, sum, and variance of the data.

Of course, EXCEL has special functions to complete these functions. What you need to learn is that the subtotal function can complete some methods and techniques that are difficult to complete with other functions. First, take a look at the explanation of the subtotal function in the EXCEL help file.

Subtotal function syntax: subtotal(function_num, ref1, ref2, ...)

First parameter: Function_num is a number between 1 and 11 (including hidden values) or 101 and 111 (ignoring hidden values), specifying which function to use to perform classification and summary calculations in the list.

Second parameter: Ref1 and ref2 are 1 to 254 areas or references to be calculated for classification and summary.

The key to using the subtotal function lies in the selection of the first parameter.

The function table corresponding to the subtotal first parameter code is shown in the figure below:

Excel2010

The subtotal function is relatively comprehensive and has its uniqueness and limitations compared with other specialized functions:

1: You can ignore hidden cells and operate on the results of visible cells; it is often used with filtering, but it is only effective for row hiding and invalid for column hiding; the difference between the first parameter and the second parameter for hiding is: Manual hiding has the same effect on filtering.

2: Support three-dimensional operations.

3: Only supports references to cell ranges

4: The first parameter supports array parameters.

The above is all the content that the editor shared with you about how to use the subtotal function in Excel2010 functions. I hope everyone can apply what they have learned! For more exciting tutorials, remember to follow Huajun Software Park!