Use COUNT function to count the number of cells with parameters

Uploaded time: 2021-08-30 Difficulty: Primary

Use COUNT function to count the number of cells with parameters

Use COUNT function to count the number of cells with parameters

Graphic skills

When we do data statistics, we can use the COUNT function to count the number of cells containing values.

 

Take this table as an example. We need to count the number of cities participating in donations. Click cell E6 and click Insert Function to find the COUNT function. Click the OK button, now a dialog box will pop up.

COUNT (1).gif


Value 1 and Value 2 refer to the cell range to be statistically calculated. Only the numeric parameters are counted in this part of the range, that is to say, the number of cells with numerical values.  Blank cells will not be counted.

COUNT (2).gif 

Click Value 1 and select the data in the Amount column. We can quickly get the number of cells with a donation amount of 57, which means that the number of cities participating in the donation is 57.

COUNT (3).gif 

In addition, if we want to count text cells or cells containing other types of information, we can also use the COUNTA function. If we want to count the cells that meet a certain criterion, we can use the COUNTIF function or the COUNTIFS function. For further information on these functions, you are welcome to join our WPS Academy to learn more.

COUNT (4).gif