Function: COUNTIF

Function: COUNTIF

COUNTIF counts the values in a range of cells that match a given criteria. In this guide, we’re going to show you how to use the COUNTIF function and also go over some tips and error handling methods.Supported versionsAll Excel versionsSyntax COUNTIF(range,...
Count unique values Excel

Count unique values Excel

This article shows how to count unique values Excel formulas SUMPRODUCT and COUNTIF. The SUMPRODUCT function can handle arrays without actually using array formulas, and this allows evaluating the formulas in each cell of an array. Syntax =SUMPRODUCT( 1 / COUNTIF(...
How to create conditional Excel drop down lists

How to create conditional Excel drop down lists

It’s often a good idea to use drop down lists or combo boxes to limit user errors make the data more standardized. However, sometimes we want our drop downs to populate under some conditions. Here, you can find out how to create conditional Excel drop down using Data...
How to highlight values based on item lists

How to highlight values based on item lists

It’s often a good idea to highlight the duplicate values in a data set to help easily identify the outliers. Let us show you how to highlight values based on item lists using Conditional Formatting. Syntax =COUNTIF( absolute reference of list of values, relative...
How to check if a value exists in a list

How to check if a value exists in a list

The logical tests and conditional checks have important role in Excel models. Potential errors can be detected and handled by using the right logical tests. If you know How to check if a value exists in a list, you can use this logical statement to detect and...