Sum
Result is 18.5
Input
{
"data": [
{
"name": "Alice",
"score": 1
},
{
"name": "Bob",
"score": 2
},
{
"name": "Charlie",
"score": 4
},
{
"name": "Dave",
"score": 8
},
{
"name": "Bob",
"score": 16.5
}
],
"queryField": "name",
"sumField": "score",
"operator": "eq",
"criteria": "Bob",
"ignoreCase": false
}Output · HTTP 200
{
"result": 18.5
}Show curl command
curl -X POST 'https://api.1001fx.com/spreadsheet/sumif' \
-H 'X-API-KEY: YOURSECRETAPIKEY' \
-H 'Content-Type: application/json' \
-d '{"data":[{"name":"Alice","score":1},{"name":"Bob","score":2},{"name":"Charlie","score":4},{"name":"Dave","score":8},{"name":"Bob","score":16.5}],"queryField":"name","sumField":"score","operator":"eq","criteria":"Bob","ignoreCase":false}'