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.
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 ==
Possible values are: >, >=, <, <=, !=, ==
Example:
==criteriastring
Criteria to look for must be number or string
Example:
AlicesumFieldstring
Name of the field in data to sum up. Case sensitive.
Example:
scoreignoreCaseboolean
Sets case sensitivity for criteria operation. Defaults to true
Example:
Available on
