SUMIFS Function

This article explains how to use SUMIFS functions

Sample Usage

FS
SUMIFS(DA_C, DA_A, 1, DA_B, 2)
FS
SUMIFS(DA_C, DA_A, QA, DA_B, QB)

Syntax

FS
SUMIFS(find_column_reference, criteria_column_reference1, criterion1, [criteria_column_reference2, criterion2, …])

Part of the formula between brackets [] is optional. You don't include the brackets in your actual formula

The formula can look overwhelming, but is actually pretty simple.

  • You first provide the column number in which you want to retrieve the result with find_column_reference
    • aka the column reference to be summed.

The next part are pairs for all the conditions you want to check. You first provide the column reference where to match the condition and secondly provide the condition to be met, e.g. QA, QB{spreadsheetTime} or VA:

  • criteria_column_reference1
    • the column reference of cells to be evaluated by criterion1.
  • criterion1
    • the condition to be met by cells in criteria_column_reference1.
  • criteria_column_reference2, criterion2, … (optional) - additional column references and criteria to test.

Example calculator

ConvertCalculator Icon

The and