by Ilker | Mar 26, 2020 | Excel Tips & Tricks
The COUNTIFS and COUNTIF functions can count the values in ranges which meet certain criteria. Although the COUNTIFS function accepts multiple range-criteria pairs, it doesn’t allow using different size ranges. You can overcome this with the help of the SUM and...
by Ilker | Dec 21, 2018 | Excel Formulas
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 versions All Excel versions Syntax COUNTIF(range,...
by Ilker | Jul 18, 2018 | Excel Tips & Tricks
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(...
by Ilker | Jul 12, 2018 | Excel Tips & Tricks
This article explains how to convert Excel columns to rows, also knows us unpivoting, using VLOOKUP formula. Unpivoting is the opposite of pivoting data (see Pivot Tables) by distributing values from a single column to multiple columns while keeping unique values in...
by Ilker | Jul 12, 2018 | Excel Tips & Tricks
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...
by Ilker | Jul 12, 2018 | Excel Tips & Tricks
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...
by Ilker | Jul 9, 2018 | Excel Tips & Tricks
Entering data into an Excel file manually carries the risk of incorrect entries. Using Excel data validation feature reduces and in many cases complete eliminates this risk. In this article, we are going to show how to combine COUNTIF function with Data Validation...
by Ilker | Jun 6, 2018 | Excel Tips & Tricks
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...
by Ilker | May 30, 2018 | Excel Tips & Tricks
Using the versatile COUNTIF and COUNTIFS functions, see how you can count cells up to a certain date. How to count values if date is less than by using COUNTIF function article shows an essential tip for creating YTD (year-to-date) reports. Syntax =COUNTIFS(date...
