GROUPBY / PIVOTBY

Namespaced Aliases

GB_GROUPBY

Collision-resistant alias for GROUPBY.

Syntax

=GB_GROUPBY(row_fields, values, function_name, [field_headers], [total_depth], [sort_order], [filter_array])

Parameters

Namerow_fields
Typerange
DescriptionOne or more columns used to group rows.
Namevalues
Typerange
DescriptionOne or more columns containing values to aggregate.
Namefunction_name
Typetext or range
DescriptionAggregation name such as "SUM" or "TEXTJOIN: | ".

Returns

The same spilled summary table as GROUPBY.

Example

=GB_GROUPBY(A1:A6, C1:C6, "SUM", TRUE)

Result: East 215; West 75

Notes

GB_GROUPBY accepts the same optional arguments as GROUPBY.

Use the alias when you want formulas with a family prefix.

    xs