Excel counting functions: Count and Countif

The regular processing of data calculations with Excel spreadsheets, there will be a lot when you need to use the counting function. COUNT and COUNTIF are the 2 most basic counting functions, easy to use but for those who are new to Excel, you may not know how to use it.

The regular processing of data calculations with Excel spreadsheets, there will be a lot when you need to use the counting function. COUNT and COUNTIF are the two most basic counting functions, easy to use, but for those of you who have just learned about Excel, you probably don't know how to use them.

Excel counting functions: Count and Countif Picture 1Excel counting functions: Count and Countif Picture 1

Those of you who do not know how to use COUNT and COUNTIF can refer to the article below, the tutorial how to use the same examples directly using COUNT and COUNTIF functions help you understand better.

COUNT function

1. Functions

The Count function is used to count the number of cells containing numeric data in the selected area.

There are also the following counting functions:

Counta function: Counts the number of cells containing data in the selected area.

Countifs function: Statistical conditional function.

Countblank function: Count the number of blank cells in the selected area.

2. Syntax

= COUNT (value1, value2 .)

Where value1, value2 . are the cells to be counted, or you can enter the areas to be counted.

3. For example.

For a data table, ask to count the number of students who have scored in the Scores column (those who do not have points are those you owe).

Excel counting functions: Count and Countif Picture 2Excel counting functions: Count and Countif Picture 2

Use the Count: = COUNT function (E5: E14)

Excel counting functions: Count and Countif Picture 3Excel counting functions: Count and Countif Picture 3

COUNTIF function

1. Functions

The Countif function is used to count the number of cells that meet the criteria in the range.

2. Syntax

= COUNT (range, criteria)

Where: range is the area to be counted, criteria is the counting condition.

3. For example.

Give the data table as follows:

Excel counting functions: Count and Countif Picture 4Excel counting functions: Count and Countif Picture 4

Ask to count students with a score greater than or equal to 8?

Apply the COUNTIF function as follows: = COUNTIF (E5: E14, "> = 8")

Excel counting functions: Count and Countif Picture 5Excel counting functions: Count and Countif Picture 5

COUNT and COUNTIF are two pretty simple counting functions. With the above tutorial, you can use COUNT and COUNTIF functions for your work.

Good luck!

4 ★ | 2 Vote