> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-8a08bda2.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> Calculates the sum of the numbers and counts the number of rows at the same time. The function is used by ClickHouse query optimizer: if there are multiple `sum`, `count` or `avg` functions in a query, they can be replaced to single `sumCount` function to reuse the calculations. The function is rarely needed to use explicitly.

# sumCount

<h2 id="sumCount">
  sumCount
</h2>

Introduced in: v21.6.0

Calculates the sum of the numbers and counts the number of rows at the same time. The function is used by ClickHouse query optimizer: if there are multiple `sum`, `count` or `avg` functions in a query, they can be replaced to single `sumCount` function to reuse the calculations. The function is rarely needed to use explicitly.

**See also**

* [`optimize_syntax_fuse_functions`](/reference/settings/session-settings#optimize_syntax_fuse_functions) setting.

**Syntax**

```sql theme={null}
sumCount(x)
```

**Arguments**

* `x` — Input value. [`(U)Int*`](/reference/data-types/int-uint) or [`Float`](/reference/data-types/float) or [`Decimal`](/reference/data-types/decimal)

**Returned value**

Returns a tuple `(sum, count)`, where `sum` is the sum of numbers and `count` is the number of rows with not-NULL values. [`Tuple`](/reference/data-types/tuple)

**Examples**

**Basic usage**

```sql title=Query theme={null}
CREATE TABLE s_table (x Int8) ENGINE = Log;
INSERT INTO s_table SELECT number FROM numbers(0, 20);
INSERT INTO s_table VALUES (NULL);
SELECT sumCount(x) FROM s_table;
```

```response title=Response theme={null}
┌─sumCount(x)─┐
│ (190,20)    │
└─────────────┘
```

**See also**

* [optimize\_syntax\_fuse\_functions](/reference/settings/session-settings#optimize_syntax_fuse_functions) setting.