sumif - Sumif Spreadsheet Function for an Array
Implements a sumif function similar to GSheet and Excel functions. Sum elements of an array by a given criterion.
dataarray
Array of objects with at least two properties e.g. [{name,score}] each.
Minimum: 1
Example:
[
{
"name": "Alice",
"score": 1
},
{
"name": "Bob",
"score": 2
},
{
"name": "Charlie",
"score": 4
},
{
"name": "Dave",
"score": 8
},
{
"name": "Bob",
"score": 16.5
}
]queryFieldstring
Name of the field in data to look for critera. Case sensitive
Example:
nameoperatorstring
Comparison operator. Defaults to eq
Possible values are: eq, gt, ge, lt, le, ne
Example:
eqcriteriastring
Criteria to look for must be number or string
Example:
BobsumFieldstring
Name of the field in data to sum up. Case sensitive.
Example:
scoreignoreCaseboolean
Sets case sensitivity for criteria operation. Defaults to true
Available on
