FUNCTION CATALOGUE / LOOKUP & REFERENCE
GROUPBY Excel function
Groups and aggregates data by row fields in supported Microsoft 365 versions.
Correct sentence to use
Group [values] by [row fields] and calculate [aggregation].
Modify this query in PlainFormula →Example formula
=GROUPBY(A2:A100,B2:B100,SUM)
Groups data and applies an aggregation where supported.
Syntax
GROUPBY(row_fields, values, function, [field_headers], [total_depth], [sort_order], [filter_array], [field_relationship])
Argument signature: row_fields, values, function, [field_headers], [total_depth], [sort_order], [filter_array], [field_relationship]
Availability note
Microsoft 365 builds that include this function; check update channel and platform.