### SUMPRODUCT with Criteria in Excel (5 Methods)

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)

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

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)

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)

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)

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

### How to Use MAX IF Function in Excel

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 ISNUMBER Function in Excel (7 Examples)

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)

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)

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)

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)

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)

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)

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