Efficient statistics with statistical functions

Uploaded time: September 30, 2021 Difficulty: Primary

Efficient statistics with statistical functions

Efficient statistics with statistical functions

Tips: After starting to play, you can adjust the video clarity, click

Quality

Auto 720p

Graphic skills

COUNT function and COUNTIF function are used very frequently in statistical functions. Today I'll talk about how to use these two functions.

 

· 1. COUNT function

Take this donation list as an example. We need to count the number of cities with donation amounts. At this point, we can use COUNT function. Click cell E6, enter =COUNT(C3-C75), and press the Enter key to get the result.

1 (1).gif

 

It is important to note that the COUNT function can only count the statistical cells. The forms like blank cells and text can not be counted. This case makes use of the COUNT function's inability to count blank cells and give the correct statistics for cells with donation amounts.

1 (2).gif

 

· 2. COUNTIF

If we want to count the number of cities with donation amounts greater than 50,000, we can use the COUNTIF function.

Click cell E10, enter =COUNTIF(C3-C75,>50000) and press the Enter key to get the result.

1 (3).gif

 

The function formula has two parameters: Range and Criteria.

Range is a statistical range, that is cell range C3-C75 in this table. Because we count the number of cities with donation amounts greater than 50,000, >50,000 is our criteria.

Remember to use double quotes when entering criteria.

1 (4).gif

 

To learn more about how to use the statistical functions, you're welcome to enter WPS Academy.