1, SUM function, sum function is a very simple function, it is a mathematical and trigonometric function, you can add the values.

2. The conditional summation function SUMIF is to sum the contents that meet the conditions, for example =SUMIF(H2:H7, ">; =60 ",H2:H7), that is, the data greater than or equal to 60 in cells H2 to H7 are added.

3.IF function, which is a logical judgment function. The simple form of the IF function is: IF (if the content is true, the first value is returned, otherwise other values are returned).

4. Search function. A lookup function can query a row or column and find a value in the same position in another row or column. It has vector form and array form.

5.VLOOKUP function. The VLOOKUP function is used to find the contents of a table or range by row, for example, to find the employee's last name by employee number. He is a member of the search function family. The syntax of VLOOKUP is =VLOOKUP (search value, including the range of search value, column number of the value to be returned, precise search/fuzzy search).