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.

• 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 of 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 criteriacolumnreference1.
• criteria_column_reference2, criterion2, … (optional) - additional column references and criteria to test.

Example calculator