COUNTIF Function

### Character Code for Check Mark in Excel (5 Suitable Findings)

Say, you want to make a to-do list. So, what will you do? Make a list and after finishing the work, you will give a check mark on that job, right? ...

### Excel If Cell Begins with Certain Text Then Return Value

While working on a large dataset sometimes you need to check certain values that begin with specific data. In case you work on a smaller dataset ...

### Stem and Leaf Plot in Excel: A Robust Tool to Visualize Data

Stem and leaf plots are useful tools for organizing and displaying numerical data. They provide a simple way to visually represent data without ...

### Excel MIN Function Returns 0: 2 Possible Scenarios

You may use Excel’s MIN function to get the minimum value from a range of cells. In some cases your Excel MIN function returns 0. In this article, ...

### How to Use Named Range in Excel VLOOKUP Function

The VLOOKUP function is one the most commonly used functions in Microsoft Excel. We use the VLOOKUP function to find values in a table to extract ...

### How to Create Reverse Mortgage Calculator in Excel

Senior citizens in many countries can utilize their home’s equity to obtain cash. This process is known as the reverse mortgage. In this article, we ...

### How to Use Excel LARGE Function with Duplicates in Excel

The LARGE function cannot identify the unique nth largest value if duplicates are available in an array. In this article, you will find the nth ...

### How to Use COUNTIF & ISNUMBER to Count Numbers in Excel

Microsoft Excel facilitates us to estimate various types of data as well as perform monetary, arithmetic, and statistical computations. Sometimes we ...

### How to Use “Not Equal to” Operator for Text in Excel (5 Examples)

When you want to compare one text with another in Excel, Logical Operators pave the ways for performing this task. If one text is not equal to ...

### How to Return TRUE If Cell Contains Text in Excel (8 Easy Ways)

Sometimes we need to determine whether a cell contains text or not. Because that cell might be needed for other purposes where the cell format needs ...

### How to Make a Vacation Calendar in Excel (with Detailed Steps)

There are several vacation days throughout the year. Usually, companies make a list of those vacation days and send it to the employees. But we can ...

### How to Check If Cell Contains One of Several Values in Excel

Looking for ways to check if a cell contains one of several values in Excel? Then, this is the right place for you. Using different functions, you ...

### Check If Cell Contains Text Then Return Value with Multiple Conditions in Excel

Looking for ways to check if a cell contains text and then return value with multiple conditions in Excel? Then, this is the right place for you. ...

### How to Use ODD Function in Excel (3 Examples)

There are lots of functions in Excel to perform specific tasks. One of them is this ODD function. We use this function to get odd values. In this ...

### How to Count Frequency of Unique Values in a Column in Excel

Excel by Microsoft is a user-friendly program that more than lives up to its stellar reputation. We can do various operations on a dataset thanks to ...

Advanced Excel Exercises with Solutions PDF