How to use the SUMIF function

The SUMIF function in Excel is used to add up values in a range that meet certain criteria.

  • range: This is the range of cells that you want to evaluate against the given criteria. This can be a single column or row, or a range of columns or rows.

  • criteria: This is the condition that you want to test against. This can be a numeric value, text string, cell reference, or even a formula.

  • [sum_range]: This is an optional argument that specifies the range of cells that you want to add together. If this argument is omitted, the function will add up the values in the range specified by the “range” argument.

For example, suppose you have a list of sales data for different products, and you want to calculate the total sales for a specific product. You can use the SUMIF function to add up all the sales for that product by specifying the product name as the criteria.

In this example, B4:B12 is the range of cells containing the product names, B14 is the criteria we want to match, and E4:E12 is the range of cells containing the sales data we want to add up. The function will only add up the sales data for the rows where the product name matches “Jersey”.

Share to social media