# SUM

```
SUM(numExpr)
```

Returns the sum of all the values, in the expression. It can be used with numeric input only. Null values are ignored.

Available in:

| Processor (stateless) | Processors (stateful) | SQL Studio |
| --------------------- | --------------------- | ---------- |
| ✓                     | ✓                     | ✓          |

*Sample code:*

```sql
USE `kafka`;
SELECT SUM(total) 
FROM orders-events
```

*Output:*

```json
{
  "value": {
    "SUM": "163053.270000000000000000"
  }
}
```