# SUMIFS Function

This article explains how to use SUMIFS functions

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.