SUMPRODUCT Function

### How to Sum Based on Column and Row Criteria in Excel (7 Ways)

There is a wide range of suitable methods to sum up a range of cells based on column and row criteria in MS Excel. In this article, we’ll try to ...

### How to Perform SUMIF by Month Operation in Excel

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. In this ...

### SUMIF with Multiple Criteria in Different Columns in Excel

We often need to sum data that fulfill particular criteria. The summation may include fulfilling multiple criteria in different columns. Excel ...

### Apply COUNTIF Function in Multiple Ranges for Same Criteria

Sometimes we may need to work with multiple ranges on the same criteria in terms of searching, counting, or sorting. In this way, Microsoft Excel ...

### How to Count Visible Rows in Excel (3 Suitable Methods)

While dealing with a large dataset, adding many rows to your worksheet is necessary. But at the same time, you may need to hide some rows to give the ...

### How to Apply COUNTIF Between Two Cell Values in Excel

In MS Excel there are several functions purposed for counting different kinds of cells, such as blanks or non-blanks, with a number, date, or text ...

### Excel SUMPRODUCT Function to Count Unique Values with Criteria

In MS Excel, the SUMPRODUCT function provides plenty of complex calculations from the arrays which can be used to count unique values under single or ...

### How Do I Count Cells with Text In Excel (8 Quick Tricks)

In this tutorial, I am going to show you 8 quick tricks to count cells with text in excel. You can use these methods even in large datasets to find ...

### Excel COUNTIF for Multiple Criteria with Different Column

If you are looking for Excel COUNTIF multiple criteria with different column, then you are in the right place. While using Excel, we often need to ...

### COUNTIF with Multiple Criteria in Different Columns in Excel

Microsoft Excel has provided very useful & common functions named COUNTIF & COUNTIFS to count cells under multiple criteria in different ...

### How to Count Unique Values Using Excel Formula (4 Easy Ways)

Working with a large dataset in Excel, you may often need to know how many duplicate and unique values are there. You are definitely not going to ...

### How to Extract Only Numbers from Excel Cell (7 Easy Ways)

Although Microsoft has not provided a straight formula or syntax to extract only numbers from the Excel cell, we can incorporate a wide range of ...

### How to Count Cells That are Not Blank in Excel (8 Useful Methods)

In this tutorial, I am going to show you 8 useful methods to count cells that are not blank in excel. You can use these methods even in large ...

### How to Count Matches in Two Columns in Excel (5 Easy Ways)

Microsoft Excel provides a wide range of fruitful techniques to count matches of data in two columns under many different criteria. In this article, ...

Advanced Excel Exercises with Solutions PDF