Introduction to Excel Common functions (5)

29. Sum function

Function Name: SUM

Main function: Calculates the value of all parameters.

Use format: SUM (Number1,number2 ...) ）

Parameter description: Number1, Number2 ... Represents a value that needs to be calculated, such as a specific number, a referenced cell (range), a logical value, and so on.

Application example: As shown in Figure 7, enter the formula in cell D64: =sum (d2:d63), after confirmation can find the total score of the language.

Special reminder: If the argument is an array or reference, only the numbers will be counted. Blank cells, logical values, text, or error values in an array or reference are ignored, and if you modify the above formula to: =sum (LARGE (d2:d63,{1,2,3,4,5}), you can find the first 5 results.

30. sumif function

Function Name: SUMIF

Main function: Calculates the values in the range of cells that match the criteria you specify.

Use format: SUMIF (Range,criteria,sum_range)

Parameter Description: Range represents the range of cells in which the criteria are judged, criteria is the specified condition expression, and Sum_range represents the range of cells in which the value needs to be computed.

Application example: As shown in Figure 7, enter the formula in cell D64: =sumif (c2:c63, "male", d2:d63), after confirmation can find "male" students of the language results and.

Special reminder: If the above formula is modified to: =SUMIF (c2:c63, "female", d2:d63), you can find the "female" students of the language scores and the "male" and "female" because it is text-type, need to put in the English state of double quotes ("Male", "female").

31, the text function

Function Name: TEXT

Main function: Converts the corresponding number to text form according to the specified numeric format.

Use format: TEXT (Value,format_text)

Parameter Description: value represents the numeric value or reference cell that needs to be converted; Format_text is the number format for the specified text form.

Application Example: If the B68 cell has a value of 1280.45, we enter the formula in the C68 cell: =text (B68, "$0.00"), which is displayed as "$1280.45" after confirmation.

Special reminder: The Format_text parameter can be determined based on the type in the Number tab of the Format Cells dialog box.