Introduction to the count function
The count function is used to count the number of numbers in cells and parameter lists that contain numbers, and can be used to obtain the number of items in a number field or in an array of numbers.
count function function:
Returns the number of cells that contain numbers and numbers in the parameter list. The count function can be used to calculate the number of input items for a numeric field in a range of cells or an array of numbers.
count function syntax
count(value1,value2,..
Format description: count(target cell 1, target cell 2,..
count (target cell range).
Parameter description
value: A parameter that contains or references various types of data, but only numeric data is calculated.
Precautions:
The count function counts numbers, dates, or numbers represented by text;However, incorrect values or other words that cannot be converted to numbers will be ignored.
count function using an instance
Note: According to Figure 1, find the function, or directly enter =count() in the edit box, it should be noted that the equal sign and parentheses should be in English format. After entering, add the area to be calculated in parentheses, as shown in Figure 2, which is c4:c9, and in the same way, when calculating the number of people in the mathematics test, it is d4:d9.
It is also important to note that it is possible to fix rows or columns, in which case the corresponding rows and columns are preceded by a $ sign. For example, fixed d4 rows and columns, that is: $d $4, this change, you can choose to change in the formula, such as d4, and then press the f4 key to add, there are 4 modes, the rows and columns are fixed, fixed rows, fixed columns, and not fixed.
Similar to the use of execl formulas, they are basically similar, search for some specific functions on the Internet, and how to use them. Apply it a few more times in execl to get the hang of it. I hope everyone can grasp it.