Excel COUNTIF Function

COUNTIF Multiple Criteria (All Things You Need to Know)

In this article, you’ll learn how to use the COUNTIF function in Excel with multiple criteria in different scenarios with 4 suitable examples. The ...

How to Use the COUNTIF Function with an Array Criteria in Excel

In the dataset below, we have Employee Names, Working Days and employee Status according to performance. We will apply the COUNTIF function with an ...

Excel COUNTIF to Count Cells Greater Than 1 (2 Examples)

In Excel, sometimes we need to find the values that are greater than 1. If we work with a small dataset, we might be able to do it manually. But for ...

How to Use the Combination of COUNTIF and SUMIF in Excel

Method 1 - Determining Average Price Steps: Select the F5 cell and write down the following formula, ...

How to Use Excel COUNTIF Between Time Range (2 Examples)

Excel COUNTIF function is used to count based on criteria. We can set criteria according to our requirements. Time range is one of the criteria. In ...

How to Use COUNTIF Function In Excel to Count Bold Cells

We’ll walk through the steps for counting bold cells in Excel using the COUNTIF function. Let’s assume we have a concise dataset with approximately 7 ...

How to Fix If the COUNTIF Function Is Returning 0 in Excel (4 Solutions)

  Solution 1 – Insert an Inverted Comma While Using Text Value In the following dataset, we haven’t inserted the text within the double ...

How to Use SUMIF, COUNTIF and AVERAGEIF Functions in Excel: 3 Methods

Method 1 - Application of SUMIF Function in Excel ⏩ Overview of SUMIF Function The SUMIF function is used for summing numerical values based on ...

Count Text at Start with COUNTIF & LEFT Functions in Excel

Counting text or characters is a very common phenomenon among regular Excel users. Especially when we work with a large dataset with various ...

How to Use IF and COUNTIF Functions Together in Excel

Let’s consider the following dataset about the Products of ABC Traders. The dataset has two columns, B and C, called Year and Products. The dataset ...

How to Use COUNTIF and COUNTA Functions Together in Excel

While working in Excel, we often need to count the number of cells irrespective of the data type of the cell contents based on some specific ...

How to Use COUNTIF Function to Calculate Percentage in Excel

Calculating percentages is a very useful mathematical operation while working on an Excel worksheet. We can use the COUNTIF function of Excel for the ...

How to Calculate Frequency Using COUNTIF Function in Excel

If you want to calculate frequency in Excel, using the COUNTIF function is one of the smartest ways to do so. Calculating frequency means counting ...

Using the Excel COUNTIF to Count Cells That Contain Text from other Cells

  You can use the COUNTIF function to count a cell that contains text from another cell in Excel. This is the sample dataset. ...

COUNTIF Function to Count Cells That Are Not Equal to Zero

Let's use the Sales Report of a particular grocery store. This dataset contains the names of the Sales Rep, the Product Name, and their respective ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo