SUM Function Archives

INDIRECT Function with Sheet Name in Excel (4 Criteria)

Sep 23, 2021 Excel Formulas

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)

Nov 8, 2021 Excel Formulas 1

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)

Nov 25, 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. ...

How to Count Duplicates in Excel (5 Methods)

Sep 23, 2021 Excel Formulas

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)

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

Nov 14, 2021 Excel Formulas

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

Oct 18, 2021 Excel Basics

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)

Nov 1, 2021 Excel Functions

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)

Nov 2, 2021 Excel Formulas

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)

Nov 2, 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 ...

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

Nov 2, 2021 Excel Functions

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)

Nov 3, 2021 Excel Formulas

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)

Nov 1, 2021 Excel Formulas

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)

Nov 16, 2021 Excel Functions

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)

Nov 15, 2021 Excel Functions

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