GROUPBY
Helps a user group, aggregate, sort, and filter data based on the fields you specify.
Lookup & ReferenceDynamic Arrays & LAMBDALookup & Matching EssentialsModern Excel Functions
What it does
Groups data by row/column fields and aggregates values (like a formula-based PivotTable).
Syntax
GROUPBY(row_fields, values, function, [field_headers], [total_depth], [sort_order], [filter_array])
Arguments
row_fields(range) — Columns to group by.values(range) — Data to aggregate.function(function) — Aggregation function (e.g., SUM, AVERAGE).
Examples
Group Sales by Region
Sum Sales by Region.
FORMULA
=GROUPBY(A2:A10, B2:B10, SUM)
RESULT
[Region, Sum; East, 500...]
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Region | Sales |
| 2 | East | 100 |
| 3 | West | 200 |