SUMPRODUCT Function Archives

SUMPRODUCT with Criteria in Excel (5 Methods)

Oct 25, 2021 Excel Formulas

There are situations when you are comparing data between two or more ranges and calculating with multiple criteria, The SUMPRODUCT function is your ...

SUMPRODUCT Multiple Criteria (3 Approaches)

Oct 26, 2021 Excel Formulas

Circumstances may demand you to work with multiple criteria within the SUMPRODUCT function. To assist you then, today we are going to show you how to ...

How to use SUMPRODUCT IF in Excel

Oct 27, 2021 Excel Formulas

SUMPRODUCT is an extremely resourceful function with many purposes. When you are comparing data between two or more ranges and calculating with ...

COUNTIF Cell That Contains a Specific Text in Excel (Case-Sensitive and Insensitive)

Oct 24, 2021 Excel Formulas

Today I will be showing how you can use COUNTIF to count cell that contains a specific text within it. I will show both case-insensitive and ...

COUNTIF Partial Match (Couple of Easy Approaches)

Sep 23, 2021 Excel Formulas

COUNTIF is one of the most frequently used functions in Excel. A lot of tasks can be done using this function, one of them is the partial match. ...

Combining SUMPRODUCT and VLOOKUP in Excel (2 Examples)

Sep 23, 2021 Excel Basics

In Excel, you may need to use different sum family functions: SUM, SUMIF, SUMPRODUCT, and so on. Depending on circumstances, it’s quite common to ...

Combining SUMPRODUCT and VLOOKUP in Excel (2 Examples)

How to Use MAX IF Function in Excel

Sep 28, 2021 Excel Formulas

While working in excel, we need to find the maximum value under a given condition. The combination of the MAX function and IF function can help you ...

How to use ISNA function in Excel (4 Examples)

Sep 22, 2021 Excel Functions

Excel provides several information functions to provide you the necessary information and help you perform your desired tasks easily and swiftly. ...

How to Use ISNUMBER Function in Excel (7 Examples)

Sep 22, 2021 Excel Functions

In Microsoft Excel, the ISNUMBER function is generally used to check whether a given argument contains a numerical value or not. In this article, ...

How to use SUBSTITUTE function in Excel (4 Examples)

Sep 22, 2021 Excel Functions

There are several text functions in Excel to help you perform your desired tasks easily and swiftly. Today we are going to show you how to use a text ...

How to Use ISERROR Function in Excel (With 5 Examples)

Sep 22, 2021 Excel Formulas

For ignoring any type of calculation error, it is better to use exception handling. MS Excel provides an ISERROR function for this purpose. This ...

How to Use LEN Function in Excel (Formula and VBA Code)

Sep 22, 2021 Excel Formulas

Excel provides a function called LEN for counting letters, numbers, characters, and all spaces. LEN is a short form of LENGTH. LEN function is used ...

How to Use COUNTIF Function in Excel (10 Suitable Applications)

Sep 21, 2021 Excel Functions

In Microsoft Excel, the COUNTIF function is widely used to count cells with a given condition or criterion. In this article, you’ll get to learn how ...

How to Use SUMPRODUCT Function in Excel (4 Examples)

Oct 10, 2021 Excel Formulas

Today I will be showing how you can multiply two or more arrays and then determine its sum using the SUMPRODUCT function of Excel. SUMPRODUCT ...

How to Use SUMIFS Function in Excel (6 Handy Examples)

Sep 21, 2021 Excel Functions

In Microsoft Excel, the SUMIFS function is used to evaluate the sum from a range of cells under multiple conditions. In this article, you’ll learn ...