# AROP
```json metadata
{
"title": "AROP",
"description": "Performs aggregate operations on array elements in a range.",
"categories": ["docs","develop","stack","oss","rs","rc","oss","kubernetes","clients"],
"arguments": [{"key_spec_index":0,"name":"key","type":"key"},{"name":"start","type":"integer"},{"name":"end","type":"integer"},{"arguments":[{"name":"sum","token":"SUM","type":"pure-token"},{"name":"min","token":"MIN","type":"pure-token"},{"name":"max","token":"MAX","type":"pure-token"},{"name":"and","token":"AND","type":"pure-token"},{"name":"or","token":"OR","type":"pure-token"},{"name":"xor","token":"XOR","type":"pure-token"},{"arguments":[{"name":"match","token":"MATCH","type":"pure-token"},{"name":"value","type":"string"}],"name":"match","type":"block"},{"name":"used","token":"USED","type":"pure-token"}],"name":"operation","type":"oneof"}],
"syntax_fmt": "AROP key start end \u003cSUM | MIN | MAX | AND | OR | XOR | MATCH value |\n USED\u003e",
"complexity": "O(P) where P is visited positions in touched slices (dense scanned slots + sparse entries), with worst-case O(|end-start|+1) and typical case close to O(N), where N is the number of existing elements in range.",
"group": "array",
"command_flags": ["READONLY"],
"acl_categories": ["ARRAY"],
"since": "8.8.0",
"arity": -5,
"key_specs": [{"begin_search":{"index":{"pos":1}},"find_keys":{"range":{"lastkey":0,"limit":0,"step":1}},"flags":["RO","ACCESS"]}],
"tableOfContents": {"sections":[{"id":"required-arguments","title":"Required arguments"},{"id":"examples","title":"Examples"},{"id":"return-information","title":"Return information"}]}
,
"codeExamples": []
}
```Performs aggregate operations on array elements in a range.
## Required arguments
key
The name of the key that holds the array.
start
The zero-based integer index of the first element in the range to aggregate.
end
The zero-based integer index of the last element in the range to aggregate (inclusive). The command always scans from the lower to the higher index regardless of argument order.
operation
The aggregate function to apply to all non-empty elements in `[start, end]`. One of:
- **`SUM`** — Returns the sum of all numeric values as a bulk string.
- **`MIN`** — Returns the minimum numeric value as a bulk string.
- **`MAX`** — Returns the maximum numeric value as a bulk string.
- **`AND`** — Returns the bitwise AND of all values, treating each as an integer (floats are truncated toward zero).
- **`OR`** — Returns the bitwise OR of all values, treating each as an integer (floats are truncated toward zero).
- **`XOR`** — Returns the bitwise XOR of all values, treating each as an integer (floats are truncated toward zero).
- **`MATCH value`** — Returns the count of elements whose value equals `value` as an integer reply.
- **`USED`** — Returns the count of non-empty elements in the range as an integer reply.
`SUM`, `MIN`, and `MAX` return nil when no numeric elements are present in the range. `AND`, `OR`, and `XOR` return nil when the range is empty.