FUNCTION CATALOGUE / LOOKUP & REFERENCE
PIVOTBY Excel function
Groups and aggregates data by row and column fields in supported Microsoft 365 versions.
Correct sentence to use
Group [values] by [row fields] and [column fields], calculating [aggregation].
Modify this query in PlainFormula →Example formula
=PIVOTBY(A2:A100,B2:B100,C2:C100,SUM)
Creates a grouped two-dimensional summary where supported.
Syntax
PIVOTBY(row_fields, col_fields, values, function, [field_headers], [row_total_depth], [row_sort_order], [col_total_depth], [col_sort_order], [filter_array], [relative_to])
Argument signature: row_fields, col_fields, values, function, [field_headers], [row_total_depth], [row_sort_order], [col_total_depth], [col_sort_order], [filter_array], [relative_to]
Availability note
Microsoft 365 builds that include this function; check update channel and platform.