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 | Mar 5, 2020 | Excel Tips & Tricks
The COUNTIFS function can count the values in multiple ranges with multiple criteria. The function counts each given range-criteria pair and combines the result with AND logical operator. Unfortunately, there is no quick and easy way to use an OR logic with the...
by Ilker | Oct 26, 2018 | Excel Formulas
COUNTIFS function can count the values in a range of cells, based on some criteria. In this guide, we’re going to show you how to use the COUNTIFS function and cover some examples and error handling methods. Supported versions (Windows) Excel 2007 and above (Mac)...
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 13, 2018 | Excel Tips & Tricks
To count by week number is a bit different than by month. Instead of finding the start and end dates of the date range, we focus on exact week number using the WEEKNUM function. Syntax =COUNTIFS( range of week number helper column, current week number) Steps Add a...
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 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 | Jun 13, 2018 | Excel Tips & Tricks
You can count values in Excel by multiple criteria using the COUNTIFS function. However COUNTIFS will only link those criterion by AND operation. If you want to COUNTIFS OR, you need an alternative approach. This article shows how to count values with OR operator...
by Ilker | Jun 11, 2018 | Excel Tips & Tricks
To count by month has nothing different than How to COUNT values between two dates. However, this article shows you a more dynamic and specialized way with EOMONTH function that you don’t need to guess how many days in a month to count month. If you only want to...