WPS Office

Free All-in-One Office Suite with PDF Editor

Read, edit, and convert PDFs with the powerful PDF toolkit.

Microsoft-like interface, easy to use.

Windows • MacOS • Linux • iOS • Android

# Efficient statistics with statistical functions

Uploaded time: September 30, 2021 Difficulty Intermediate

# Efficient statistics with statistical functions

Efficient statistics with statistical functions

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.

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.

· 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.

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.