SUMPRODUCT Function

How to Sum Filtered Cells in Excel (5 Suitable Ways)

Sometimes it becomes a necessity for us to know the sum of some filtered cells. Though we can do it manually, Excel has some fantastic features to ...

How to Multiply One Cell by Multiple Cells in Excel (4 Ways)

Multiplying multiple cells cells in Excel is a familiar task for every Excel user. We do it to serve the different purposes of our daily life. In ...

How to Highlight Duplicates in Two Columns Using Excel Formula

If you are looking for some special tricks to highlight duplicates in two columns using the Excel formula, you've come to the right place. In ...

Count Unique Text Values with Criteria in Excel (5 Methods)

This article illustrates 5 methods on how to count unique text values with criteria in excel. You may need to extract customer names who appear ...

How to Count Characters in Cell up to Space in Excel

This article illustrates how to count characters in a cell up to space in excel. Other examples of counting characters in cells in excel are also ...

How to Count Repeated Words in Excel (11 Methods)

In Microsoft Excel, we work with a large amount of data. In a large datasheet, usually, we see some repeated words. It is tiresome to find out those ...

How to Count Only Visible Cells in Excel (5 Tricks)

Sometimes, In excel, we need to count only visible cells. For instance, when you apply a Filter to excel data, certain rows become hidden. Besides, ...

How to Count Duplicates Based on Multiple Criteria in Excel

In Excel, you may have duplicate data in the same columns. These data may be a part of a unique set when you consider all the data along a row. To be ...

How to Ignore Blanks and Count Duplicates in Excel (3 Ways)

It's common that blanks exist in Excel datasets. There are incidences, where we want to count duplicates in Excel as well as ignore blanks. Counting ...

How to Count Non Blank Cells with Condition in Excel (6 Methods)

While dealing with a large Microsoft Excel, sometimes we need to count non-blank cells with several conditions. In our Excel worksheet for the ...

Excel Formula to Count Cells with Specific Color (4 Ways)

Coloring cells is a popular method to visualize data in an Excel worksheet. Sadly, there is no in-built function in Excel to do it. We're going to ...

How to Count Duplicate Values in Multiple Columns in Excel (6 Ways)

If you are looking for some of the easiest ways to count duplicate values in multiple columns in Excel, then you will find this article useful. ...

How to Count Number of Cells with Dates in Excel (6 Ways)

Excel sheets can be used to keep track of time, date, schedule events, and activities, keep track of objects and their prices, and much more. In this ...

How to Count Filtered Cells with Text in Excel (3 Methods)

We may sometimes need to count the Excel cells with text for different purposes. That is not hard to do. But, things get complicated when we try to ...

How to Perform VLOOKUP with Multiple Rows in Excel (5 Methods)

While working with the Microsoft Excel dataset, sometimes we need to look up unique values from multiple rows. We can easily do that by applying the ...

ExcelDemy
Logo