SUMPRODUCT Function Archives

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

Apr 27, 2022 Excel Formulas

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)

May 24, 2022 Excel Formulas

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

Apr 10, 2022 Excel Formulas

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)

Apr 9, 2022 Excel Formulas

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

Mar 17, 2022 Excel Formulas

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)

Mar 16, 2022 Excel Formulas

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)

May 25, 2022 Excel Formulas

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

May 25, 2022 Excel Formulas 1

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)

May 25, 2022 Excel Formulas

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)

May 25, 2022 Excel Formulas

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)

May 25, 2022 Excel Formulas

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)

May 25, 2022 Excel Formulas

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)

May 25, 2022 Excel Formulas

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)

May 25, 2022 Excel Formulas

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)

May 23, 2022 Excel Functions

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