### INDIRECT Function with Sheet Name in Excel (4 Criteria)

In Microsoft Excel, the INDIRECT function is generally used to return the reference specified by a text string. In this article, you’ll learn how you ...

### VLOOKUP SUM Multiple Rows (4 Ways with Alternative)

In MS-Excel VLOOKUP is the most used important function to search any data from a dataset or table. In terms of calculation, sometimes we may need to ...

### COUNTIF Partial Match in Excel (2 or More 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. ...

### How to Count Duplicates in Excel (5 Methods)

While working with a large amount of data or compiling multiple worksheets into a bigger one, duplicate values, columns or rows may appear. Sometimes ...

### 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 LARGE Function in Excel (6 Easy Examples)

When we need to find a specific largest value, like the 2nd or the 3rd biggest number in any dataset. The Excel’s LARGE function returns numeric ...

### How to Copy a Formula in Excel with Changing Cell References

Do you need to copy formulas or functions in excel with or without changing cell references? There are lots of ideas and techniques to do it without ...

### How to use XLOOKUP function in Excel (7 Examples)

There are several lookup functions in Excel to perform various lookup and searching operations easily and swiftly. Today we are going to show you how ...

### How to Use SUMIF Function in Excel (With 5 Easy Examples)

In terms of calculating the summation of some numbers sometimes we may need to apply conditions or criteria. MS Excel helps us with these kinds of ...

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

### How to Use MOD Function in Excel (9 Suitable Examples)

In Microsoft Excel, the MOD function is widely used to extract the data from the series of nth rows or columns for calculation and other purposes. In ...

### How to Use SUM Function in Excel (With 6 Easy Examples)

MS Excel provides a most useful function called SUM for summation purposes. Formula with this function automatically updates with the addition or ...

### How to Use FILTER Function in Excel (9 Easy Examples)

Excel 365 provides us a powerful function for automatically filtering our datasets, named the FILTER function. It makes our task easier by using this ...

### How to Use INDIRECT Function in Excel (12 Suitable Instances)

In Microsoft Excel, the INDIRECT function is generally applied to store a cell reference and then use the reference value with other functions to ...

### How to use IFERROR Function in Excel (3 Examples)

There are several logical functions in Excel to perform various logical operations easily and swiftly. Today we are going to show you how to use the ... 