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

# How to use count function in Excel

July 28, 2022
3.9K Views

Count function is one of the most basic and important functions in Excel. It is used to count the number of cells that contain a particular value or text. In this article, we will discuss how to use Count function Excel and how it can be helpful in your day-to-day work. We will provide a few tips on how to use the count function effectively. We will also provide some practical examples to help you understand how it works.

The COUNT function can be used to count the number of cells that contain values greater than, less than or equal to a particular value. It can also be used to count the number of cells that are blank or non-blank. If you know that how to use count function excel you will be able to do your work in excel quickly and effectively.

How to use count function excel?

1. Open the data file you want to count.

Suppose we want to know the number of countries which have the sale in the month of March.

2. Once you open the file go to the formulas and select insert function. The insert function window will open.

3. Once you have the insert function window select the COUNT function and then click OK.

4. As you click on the ok the argument function will be opened now select the range in the value 1 option.

5. As we want to count the number of countries which have sale in march therefore the sale of march is value 1 select the value 1 and click ok.

6. As you click ok the result will be there.

How To Use Count Function Excel: with multiple values

1. Open the data file you want to count.

Suppose we want to know total number in January February and March.

2. Once you open the file go to the formulas and select insert function. The insert function window will open.

3. Once you have the insert function window select the COUNT function and then click OK.

4. As you click on the ok the argument function will be opened now select the range in the value 1 option.

5. Now select the values as you want to count if you want to count column more than 1 then select the values 1,2 and 3 and hit ok you will get the result

6. As you will click ok the result will be produced.

How To Use Count Function Excel: Count if function

We can also use the count function with special condition suppose we want to count number of sales in March which are more than 23000.

1. Choose the countif function and then click ok.

2. Now choose the range and the put the value of your condition in criteria cell and the click ok you will get the result.

3. As you click ok the excel will produce the result. Which means only 6 countries have sale more than 23000.