SheetFX
≡
<< Go back to all functions

SUMIF

The SUMIF function in Google Sheets is a powerful tool to return a conditional sum across a range. Whether you're calculating sales from specific regions, filtering data based on a certain criterion, or analyzing expenses based on specific categories, the SUMIF function simplifies the task. Dive into our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: SUMIF(range, criterion, [sum_range])

Parameters:

  • range: The range of cells to evaluate the criterion against.
  • criterion: The criterion or condition to be met.
  • sum_range: [Optional] The range of cells to sum if the corresponding cells in the range match the criterion.

Step-by-Step Tutorial

  1. Using SUMIF with a single criterion:

    • Example: If A1:A5 has the values Apples, Bananas, Apples, Oranges, Grapes, and B1:B5 has the values 5, 10, 7, 3, 9, then =SUMIF(A1:A5, "Apples", B1:B5) will return 12.

  2. Using SUMIF with multiple criteria:

    • Example: If A1:A5 has the values Apples, Bananas, Apples, Oranges, Grapes, and B1:B5 has the values 5, 10, 7, 3, 9, then =SUMIF(A1:A5, "Apples", B1:B5) will return 12.

Use Cases and Scenarios

  1. Sales Analysis: Calculate the total sales for a specific product category.
  2. Expense Tracking: Determine the total expenses for a specific month or category.
  3. Data Filtering: Sum values that meet a certain condition in a dataset.

Related Functions

  • SUM: Add up a series of numbers.
  • IF: Perform conditional calculations based on a given condition.
  • COUNTIF: Count cells that meet a specified criterion.

Related Articles