This article explains how to use SUMIFS functions
FSSUMIFS(DA_C, DA_A, 1, DA_B, 2)
FSSUMIFS(DA_C, DA_A, QA, DA_B, QB)
FSSUMIFS(find_column_reference, criteria_column_reference1, criterion1, [criteria_column_reference2, criterion2, …])
The 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.
find_column_reference
The next part are pairs for all the conditions you want to check. You first provide the column reference of where to match the condition and secondly provide the condition to be met, e.g., QA
, QB{spreadsheetTime}
or VA
:
criteria_column_reference1
criterion1
criteria_column_reference2
, criterion2
, … (optional) - additional column references and criteria to test.Learn more about sumifs in one of the following articles