COUNTIF Function

Excel Count Matches in Two Columns (4 Easy Ways)

Microsoft Excel provides a wide range of fruitful techniques to count matches of data in two columns under many different criteria. In this article, ...

Excel Formula to Count Cells with Text (Download Free Workbook)

Microsoft Excel provides a wide range of useful functions & methods to count cells with text or any other characters & strings. In this ...

How to Count Cells with Specific Text in Excel (Both Case Sensitive and Insensitive)

While working in Excel, we often have to count cells with some specific text. Today I will show some easy ways to achieve that. Download File ...

Count Cells that Contain Specific Text in Excel

While working with a big range of data it is often required to find the number of specific text. In this article, we will count cells that contain ...

How to Compare Two Columns or Lists in Excel

While doing different tasks in Excel we often come across a situation where the matching and differences of two or multiple columns are required. ...

How to Compare Two Columns in Excel For Finding Differences

This is an interesting situation that often comes up. Namely, sometimes one needs to differentiate data into two different columns. There are so many ...

The Different Ways of Counting in Excel

There is a total of five functions used for counting, predominantly in Excel. These are namely the COUNT Function, the COUNTA Function, the COUNTIF ...

How to Make a Frequency Distribution Table & Graph in Excel?

You can make a histogram or frequency distribution table in Excel in a good number of ways. I have summarized total 7 methods in this article. In ...

Finding out the number of duplicate rows using COUNTIF formula

Say you have a column with duplicate rows. You just want to find out which rows are duplicate and how many times they are duplicated. You can find ...

How to Find, Highlight & Remove Duplicates in Excel

Sometimes you may want that you will observe which rows are duplicates in the spreadsheet. Then you can manually delete those rows. It is easy to ...

ExcelDemy
Logo