How to use SUMIF formula in excel | Sumif Function

The SUMIF formula in Excel is used to sum up the values in a range that meets a specific criterion or condition. Here is the basic syntax for the SUMIF formula:

=SUMIF(range, criteria, [sum_range])

• range: The range of cells to evaluate the criterion against.
• criteria: The condition or criterion to be met by the cells in the range. This can be a number, text, or logical expression.
• sum_range: The range of cells that you want to sum up. This is optional if you want to sum up the same range as the range parameter.

To use the SUMIF formula, follow these steps:

1. Select a cell where you want the result to appear.
2. Type in the formula =SUMIF( and then select the range of cells you want to evaluate the criterion against.
3. Add a comma (,) and then type in the criterion or condition that you want to apply. This can be a number, text, or logical expression. If the criterion is a text, be sure to enclose it in double quotes (").
4. If you want to sum up a different range than the range parameter, add another comma (,) and then select the range of cells you want to sum up. If you want to sum up the same range as the range parameter, you can omit this parameter.
5. Close the formula with a closing parenthesis ()) and press Enter.

How to use SUMIF formula in excel;

Here is an example of the SUMIF formula in action:

Let's say you have a list of sales data for a company, and you want to sum up the sales made by a particular salesperson. You could use the following formula:

=SUMIF(A2:A10, "Ram", B2:B10)

In this formula, A2:A10 is the range of cells that you want to evaluate the criterion against (the list of salespersons), "Ram" is the criterion that you want to apply (the name of the salesperson you want to sum up), and B2:B10 is the range of cells that you want to sum up (the sales figures).

Special For You;

1. How To use sumifs formula in excel.