SUMPRODUCT Function

How to Apply SUMIFS with Multiple Criteria in Different Columns

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 SUMPRODUCT Function Based on Date Range

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. The ...

Excel SUMPRODUCT with Multiple Criteria in Same Column

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

How to Find Maximum Value in Excel with Condition (8 Examples)

In various calculations, we may need to calculate maximum values from any given dataset. Excel provides its built-in function which is the MAX ...

How to Sum Multiple Rows Using INDEX MATCH Formula

Microsoft Excel is a powerful program where we can perform numerous operations on our datasets using its tools and features. In many instances, you ...

How to Find Second Largest Value with Criteria In Excel

In this tutorial, I am going to show you 4 quick tricks to find the second largest value with criteria in excel. You can use these methods even in ...

Excel SUMIFS with Multiple Columns (8 Applications)

If you want to sum the values of some cells when they meet one or more criteria, then the SUMIFS function is an excellent choice. There are plenty of ...

Excel SUMIF with Multiple Criteria (5 Handy Examples)

For conditional sum in Excel, SUMIF is one of the most used functions provided by MS Excel. It is a combination of SUM and IF (SUM+IF), which means ...

COUNTIF Between Two Dates in Excel (4 Suitable Examples)

For different purposes, you may need to find the number of occurrences between two dates. You can fetch the count value easily once you have known ...

SUMPRODUCT Function with Multiple Columns in Excel (4 Ways)

SUMPRODUCT is one of the most powerful array functions in Microsoft Excel that can pull out data from an array based on the criteria along multiple ...

How to Sum Every Nth Column in Excel (3 Methods)

In real-life scenarios, you may deal with different sum operations in Excel, like the sum with multiple criteria, the sum entire column, the sum of ...

How to Calculate YTD (Year to Date) in Excel [9 Simple Ways]

Microsoft Excel has provided a wide range of solutions to calculate YTD (Year-to-Date) in Excel under different criteria. In this article, you’ll be ...

How to Use SUMPRODUCT to Lookup Multiple Criteria in Excel

When working with large datasets, sometimes it might occur to us that we need to sum specific cells of a column according to some specific criteria. ...

SUMPRODUCT with INDEX and MATCH Functions in Excel

In MS Excel, there is a huge diversity of using SUMPRODUCT with INDEX and MATCH functions together. In this article, I’ll try to illustrate how we ...

How to Sum Multiple Columns Based on Multiple Criteria in Excel

You may need to calculate the sum of multiple columns. Once you know the methods it will seem as easy as you like. This article will show you how to ...

Advanced Excel Exercises with Solutions PDF