How To Use SUMIF function in Excel with Examples

The SUMIF function in Excel lets you add up values in a range based on specific criteria, making it a useful tool for a variety of applications. The syntax for this function =SUMIF(range, criteria,[sum_range])

The SUMIF function in Excel allows you to quickly add a range of values based on a set of criteria. It is a versatile formula that can be used in a variety of ways, from adding up sales figures to calculating a budget.

You can use the formula to add up the sales figures for a specific item in a range of cells that contains multiple items and to add up the total sales for a particular region in a range of cells that contains multiple regions.

The function can calculate a budget just add up the budget figures for a particular expense in a range of cells that contains multiple expenses. Or add up the budget figures for a particular region in a range of cells that contains multiple regions.

=SUMIF(range, criteria, [sum_range])

Where:

• Range = the range of cells that you want to apply the criteria
• Criteria = the criteria used to determine which cells to sum
• Sum_range = the range of cells to add together (optional)

1. Open the Excel file containing the data you want to use for the function.
2. Select the cell you want to display the result of the SUMIF formula.
3. Enter the SUMIF formula into the cell by typing “=SUMIF(” Select the range of cells you want to check for the criteria.
4. Type a comma “,” Enter the criteria you want to check in the range of cells.
5. Type a comma “,” Select the range of cells you want to sum if the criteria is met.
6. Type a closing parenthesis “)”
7. Press the “Enter” key on your keyboard to execute the formula.