Use the PERCENTOF function to return the percentage that a subset makes up of a given data set. It commonly used in GROUPBY and PIVOTBY functions.

Note: PERCENTOF is logically equivalent to =SUM(data_subset)/SUM(data_all)

Syntax

The PERCENTOF function sums the values in the subset and divides it by all the values.  

=PERCENTOF(data_subset,data_all)

Argument

Description

data_subset

Required

The values that in the data subset

data_all

Required

The values that make up the entire set.

Example

Example 1 uses PERCENTOF to calculate the percentage that Bib-Shorts and Bike Racks comprise of the entire set.

=PERCENTOF(C3:C4,C3:C14)

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.