Shulou(Shulou.com)11/24 Report--

The original title: "good-bye Sum function!" Subtotal is the NO.1 of statistical function. "

Hello, Hi~, I am Tian Tian, who loves to learn from Excel.

It's time for the first phase of [0 basic Excel function] again.

Today we learn a very useful statistical function-Subtotal function.

1. The main function of this function is to help you complete all kinds of statistical calculations.

To make good use of it, you only need to remember two tips:

What is the method of statistics?

Count who?

Let's take a look at the use of the Subtotal function:

= Subtotal (summary method, summary area)

2. Screening summation many students are used to using the Sum function for data summation, but it is impossible to update the summation results according to the screening situation. And the Subtotal function can easily solve this problem.

There is a simple payroll. Now we have to calculate the total salary of the company. What should we do?

❶ type the = Subtotal function in the cell and type "(".

As you can see, there are a lot of options for us to choose from, such as average, counting, maximum and minimum, standard deviation of variance, summation and so on.

We choose 9 here, that is, sum statistics, with "," comma.

❷ We directly use the mouse to select the data range to be counted (C2:C14), and then type ")", press the enter key, and the result is calculated.

The complete formula is as follows:

= Subtotal (9 ~ C2 C14) next let's try to screen again, excluding the sales department and the after-sales department, and clicking OK, we can see that the statistical results can follow the screened data and change.

When using the Subtotal function for statistics, it will automatically identify and ignore the statistical results of the same function in the statistical region, which can effectively avoid repeated calculation. In addition to being able to identify and filter out data, it can also identify hidden data.

In this way, is the use of the Subtotal function super simple and easy to use? Let's go and try it.

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Tian Tian

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.