The output from PERCENTOF is a decimal number that can be formatted with Excel’s percentage number format.

The result is a summary table created with a single formula.

PIVOTBY Function

The Excel PIVOTBY function is designed to summarize data by grouping rows and columns.

Excel GROUPBY function

The result is a dynamic summary table created with a single formula.

Excel PIVOTBY function