Skip to content
ExcelExcel Microsoft 365+

PERCENTOF function in Excel

Sums the values in the subset and divides it by all the values

=PERCENTOF(data_subset, data_all)

PERCENTOF syntax and parameters

Two arguments, two required.

  • data_subsetarrayRequired

    The values that in the data subset

  • data_allarrayRequired

    The values that make up the entire set.

PERCENTOF examples

Formulas you'll actually reuse.

  1. One region's share of total revenue — subset over whole:

    =PERCENTOF(C2:C48, C2:C200)

    Result0.353

  2. Every region's share of the total in one GROUPBY:

    =GROUPBY(A2:A200, C2:C200, PERCENTOF)

PERCENTOF in Google Sheets

No direct equivalent — here's the way around.

Try PERCENTOF in the playground

Edit the example — nothing to install.

Preloaded with the PERCENTOF formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.