Latest Posts

Sum with INDEX-MATCH Functions under Multiple Criteria in Excel

While working with a large amount of data in Excel, it’s very common to use INDEX-MATCH functions to lookup parameters under multiple criteria for ...

Reference Operator in Excel [Basics + Special Uses]

It is highly unlikely that you'd be an Excel user without having heard of reference operators. We use these essential operators frequently. And this ...

Excel Top 10 List with Duplicates

For different purposes, you may need to find the top n number of values in Excel, n can be 5 or 10 and many more. Today we are going to show you how ...

How to Find Top 5 Values and Names in Excel (8 Useful Ways)

Microsoft Excel has provided numerous ways to determine the top 5 values or names or both from a huge range of data. In this article, you’ll get to ...

Excel If Statement with Multiple Conditions in Range (3 Suitable Cases)

Today I will be showing how you can use the IF statement with multiple conditions in any range in Excel. Download Practice Workbook Excel ...

SUMIFS Multiple Criteria Different Columns (6 Effective Ways)

Sometimes we may need to get a summation based on different criteria. For this purpose, Excel provides a function called SUMIFS. This is the updated ...

Excel Find Similar Text in Two Columns

Depending on the circumstances you may need to find similar text within two columns in Excel. Today, we are going to show you how to find similar ...

SUMPRODUCT Date Range [7 Productive Methods]

When working with data sets that contain dates, it is possible that you may need to sum the values based on the provided date regularly. SUMPRODUCT, ...

SUMPRODUCT Multiple Criteria Same Column (3 Useful Ways)

When we need to compare data in two or more ranges and calculate data with multiple criteria or conditions, Excel provides a function named ...

Return Multiple Values in Excel Based on Single Criteria (3 Options)

Today I am going to show how you can return multiple values based on single criteria in Microsoft Excel. Download Practice Workbook Return ...

How to Use COUNTIF for Date Range in Excel (6 Suitable Approaches)

In MS Excel, the COUNTIF function is used to count cells under different criteria. In this article, you’ll learn effectively how you can use this ...

Excel MIN and MAX in Same Formula

You may have used the MIN and the MAX function separately in Excel many times. But when it matters to use the functions within the same formula, you ...

SUMIF with INDEX and MATCH Functions in Excel

In Microsoft Excel, the SUMIF with INDEX-MATCH functions is widely used to extract the sum based on multiple criteria from different columns & ...

Excel Find Lowest Value with Criteria [9 Effective Ways]

Finding the lowest value may be an essential task in some cases. Have you tried this basic calculation? In this article, I’ll show nine effective ...

How to Compare Rows in Excel for Duplicates

Today I will be showing how you can compare rows in Excel for finding duplicates. Download Practice Workbook How to Compare Rows in Excel ...

ExcelDemy
Logo