When using Excel tables for data statistics and processing, it is often necessary to perform statistical operations on information. At this time, you need to use the statistical function of excel. Speaking of excel statistical function, it is a very extensive content, covering many functions. Here are some commonly used statistical functions, which I hope will help you. The operation of other functions is in Oh, there are special function articles, all of which are video tutorials of Excel, which can be studied at home.

Excel common statistical function using tutorial;

1. First, create and open an excel form. We can input some data information to facilitate the demonstration operation. As shown in the figure below:

2. We carefully checked the contents of the form:

Here, let's share the meaning of this function. The COUNTIF function we use is a statistical function, and its function is to count the number of cells that meet certain conditions.

But its function is not only so simple, it also has the function of counting non-empty cells. If you want to calculate the number of non-empty cells in column A, the function formula should be like this: = countif (a: a, "

To count the number of people born in Beijing, the formula should be entered as =COUNTIF(D2:D6, "Beijing"), as shown in the following figure:

If you want to count the number of people over 30, you can enter the formula =COUNTIF(B2:B6, "& gt30").

Excel statistical function, seemingly simple function, has great statistical function! Especially when the number is large, the statistical function can give you the data you want immediately.