Learn How to Use Microsoft Excel SUMIF Function

Microsoft Excel SUMIF Function

The main function of the Microsoft Excel SUMIF function is to sum the numbers in a range that meet the required criteria. That implies, with the help of SUMIF function you can able to return the sum of cells that meet the single condition. It should be noted that criteria can be applied to dates, numbers, and text. The SUMIF function also supports logical operators like (>,<,<>,=) and wildcards (*,?) for partial matching. So, with the help of the SUMIF function, you can able to sum the numbers in a range that meet the required criteria.

Return Value of SUMIF Function

The return value will be the sum of values supplied.

Syntax of SUMIF Function

=SUMIF(range, criteria, [sum-range])

Where the arguments:

• range: This is the range of cells that you want to apply the criteria against.
• criteria: It is the criteria used to determine which cells to add.
• sum-range: This is the cells to add together. If the sum range is omitted, the cells in the range are added together instead. (optional).

How to Use Microsoft Excel SUMIF Function?

So we know that Microsoft Excel SUMIF function you can able to sum the numbers in a range that meets the required criteria. That implies, with the help of SUMIF function you can able to return a sum of cells that meet the single condition. It should be noted that criteria can be applied to dates, numbers, and text. The SUMIF function also supports logical operators like (>,<,<>,=) and wildcards (*,?) for partial matching. So, with the help of the SUMIF function, you can able to sum the numbers in a range that meet the required criteria.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel