SheetFX
≡
<< Go back to all functions

SUMIFS

The SUMIFS function in Google Sheets is a powerful tool to return the sum of a range depending on multiple criteria. Whether you're analyzing sales data, managing budgets, or evaluating project progress, the SUMIFS function simplifies complex calculations. Follow our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])

Parameters:

  • sum_range: The range to sum if the corresponding criteria are met.
  • criteria_range1: The range to check against the corresponding criterion1.
  • criterion1: The criterion to apply to criteria_range1.
  • [criteria_range2, criterion2, ...]: [Optional] Additional ranges and criteria to evaluate.

Step-by-Step Tutorial

  1. Using SUMIFS with one criterion:

    • Example: =SUMIFS(A1:A5, B1:B5, ">10")
    • Result: Returns the sum of numbers in range A1:A5 where corresponding cells in range B1:B5 are greater than 10.

  2. Using SUMIFS with multiple criteria:

    • Example: =SUMIFS(A1:A5, B1:B5, ">10", C1:C5, "<>0")
    • Result: Returns the sum of numbers in range A1:A5 where corresponding cells in range B1:B5 are greater than 10 and cells in range C1:C5 are not equal to zero.

Use Cases and Scenarios

  1. Sales Analysis: Calculate the total sales for a specific product within a given time frame.
  2. Project Management: Sum the expenses for a particular category based on multiple project criteria.
  3. Data Analysis: Aggregate the revenue from a specific region with specific product characteristics.

Related Functions

  • SUM: Add multiple numbers together.
  • SUMIF: Return the sum of a range based on a single criterion.
  • SUMPRODUCT: Multiply respective components in given arrays and returns the sum of those products.

Related Articles