1.Excel statistical function formula: summation courseware.

1, Excel statistical function: general summation.

Function: Sum the specified area or value.

Syntax structure: =Sum (value or range 1, value or range 2, ... value or range n).

Objective: To calculate the total sales volume.

Methods: Enter the formula =SUM(C3:C9) in the target cell.

2.Excel statistical function: single condition summation.

Function: Sum the qualified values.

Syntax structure: =Sumif (condition range, condition, [sum range]). When the condition range and the summation range are the same, the summation range can be omitted.

Objective: To make statistics on sales volume and sales volume by sales area.

Methods: Enter the formula =SUMIF(E3:E9, H3, C3:C9) in the target cell.

Explanation: Because the ranges of conditional areas E3:E9 and summation areas C3:C9 are different, summation areas C3:C9 cannot be omitted.

3.Excel statistical function: multi-condition summation Sumifs.

Grammatical structure: =Sumifs (sum region, condition 1 region, condition 1, [condition 2 region], [condition 2]...[ condition n region], [condition n]).

Objective: To calculate the sum of sales in different regions that are greater than the specified value.

Methods: Enter the formula = sumifs (C3: C9, C3: C9, ">" & ampE3 3: H3 E9.

1, the first C3:C9 in the formula is the sum range, and the second C3:C9 is the conditional range, so the data is relative, not absolute.

2. Using the multi-condition summation function Sumifs can complete the function of the single-condition summation function Sumif, which can be understood as the multi-condition summation with only one condition.

Second, Excel statistical function formula: counting class.

1, Excel statistical function: numerical counting.

Function: Count the number of values in a specified value or range.

Syntax structure: =Count (value or range 1, [value or range 2]...[ value or range N]).

Objective: To count the number of students taking Chinese courses.

Method: Enter the formula =COUNT(C3:C9) in the target cell.

The statistical object of the Count function is a numerical value. In C3:C9 area, the "missing test" is a text type, so the statistical result is 6.

2.Excel statistical function: non-empty count Counta.

Function: Count the number of non-empty cells in the specified area.

Grammatical structure: =Counta (region 1, [region 2]...[N region]).

Objective: To count the number of candidates.

Methods: Enter the formula =COUNTA(B3:B9) in the target cell.

Interpretation: the number of candidates is the number of all people, that is, the number of names.

3.Excel statistical function: empty Countblank.

Function: Count the number of empty cells in the specified area.

Grammatical structure: = country blank (region1,[region 2]...[N region]).

Objective: To count the number of "China people" absent.

Method: The formula in the target cell is =COUNTBLANK(C3:C9).

Interpretation: 1, the blank cell here means that there is no score and it is a lack of exams.

2. The statistical object of the countblank function is a blank cell, so the statistical result of the formula =COUNTBLANK(C3:C9) is 1.

4.Excel statistical function: single condition counting Countif.

Function: Count the number of qualified cells in the specified area.

Grammatical structure: =Countif (range, condition).

Objective: To count the number of qualified Chinese students.

Method: Enter the formula = countif (C3: C9, ">") in the target cell. & ampH3).

Interpretation: "passing" means that the score is ≥60 points.

5.Excel statistical function: multi-condition counting Countifs.

Grammatical structure: =Countifs (condition range 1, condition 1 ... condition range n, condition n).

Objective: To count the number of people who have passed both Chinese and mathematics.

Methods: Enter the formula =COUNTIFS(C3:C9, "& gt=60", D3:D9, "> =60").

Explanation: the multi-condition counting Countifs function can also complete the Countif and multi-condition counting functions that satisfy one condition.

Third, Excel statistical function formula: average class.

1, Excel statistical function: average.

Function: Returns the average of parameters.

Syntax structure: = average (value or reference).

Objective: To calculate the average score of Chinese.

Methods: Enter the formula = average value (C3:C9) in the target cell.

2.Excel statistical function: single conditional average.

Function: Calculate the average value that meets the requirements.

Syntax structure: =Averageif (condition range, condition, [numerical range]). When the condition range and the numerical range are the same, the numerical range can be omitted.

Objective: To calculate the average score of those who passed the Chinese course.

Methods: Enter the formula =AVERAGEIF(C3:C9, "& gt=60").

Explanation: According to the use, the condition range is C3:C9 and the numerical range is C3:C9, so C3:C9 of the numerical range can be omitted.

3.Excel statistical function: multi-conditional Averageifs.

Grammatical structure: =Averageifs (numerical range, condition 1 range, condition 1 ... condition n range, condition n).

Objective: To count the average scores of Chinese and mathematics.