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 COUNTIF Function with Array Criteria in Excel

While working in Microsoft Excel, sometimes we need to use the COUNTIF function with array criteria. However, it might seem difficult to you when ...

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

COUNTIF and SUMIF are two of the most effective and versatile functions in Excel.  The COUNTIF and SUMIF functions are attributed to conditional ...

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

In this tutorial, I am going to share with you step-by-step methods on how to use the COUNTIF function to count bold cells in Excel. You can easily ...

[Solved!]: Excel COUNTIF Returning 0 Instead of Actual Value

Excel COUNTIF function counts values that match criteria from a range. You may sometimes face the issue that the function is returning 0. Today, in ...

How to Use SUMIF, COUNTIF and AVERAGEIF Functions in Excel

Dealing with a set of data consisting of texts as well as numerical values of a company or an organization, it is a common scenario to feel the ...

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

While working on an Excel worksheet, you need to work with different functions. Sometimes, you need to combine the functions also to solve a problem. ...

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

Excel COUNTIF to Count Cell That Contains Text from Another Cell

The COUNTIF function counts for specific criteria. You may want to count your text dataset. The COUNTIF function helps you out in this situation. ...

COUNTIF Function to Count Cells That Are Not Equal to Zero

In our office and business work, we use Excel to calculate and organize a huge amount of data. Sometimes we feel the necessity to count some data ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo