WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

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

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to use count function in Excel

July 28, 2022
3.7K 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.

Counting in Excel has never been easier than it is now that you've read this article about how to use count function excel. If you have any questions, please feel free to leave a remark below. Visit the WPS Academy website for additional information about the WPS office. You may also download WPS Office for free from this page and use it to edit documents in the Word, Excel, PowerPoint, and PDF formats.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.