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.

data
Type
array
Required
required
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
  }
]
queryField
Type
string
Required
required
Name of the field in data to look for critera. Case sensitive
Example:
name
operator
Type
string
Comparison operator. Defaults to ==
Possible values are: >, >=, <, <=, !=, ==
Example:
==
criteria
Type
string
Required
required
Criteria to look for must be number or string
Example:
Alice
sumField
Type
string
Required
required
Name of the field in data to sum up. Case sensitive.
Example:
score
ignoreCase
Type
boolean
Sets case sensitivity for criteria operation. Defaults to true
Example:

Available on

Postman
Make
Zapier
N8N
Airtable
SeaTable
Bubble
Power Automate
Workato
SAP Build