Home › Functions › Math & Trig › PERCENTOF
fx
PERCENTOF
Math & Trig  ·  Since: Microsoft 365  ·  9 languages

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.

🌐 Translations

English PERCENTOF
Deutsch PROZENTVON
Français PERCENTOF
Español PERCENTOF
Italiano PERCENTOF
Português PORCENTAGEMDE
Nederlands PERCENTVAN
Polski PERCENTOF
Русский PERCENTOF

📦 Availability

Excel versionAvailable
Excel 2007 ✗
Excel 2013 ✗
Excel 2019 ✗
Excel 2021 ✗
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

PERCENTOF(data_subset,data_all)

Arguments

data_subset (required) — The values that in the data subset
data_all (required) — The values that make up the entire set.

▶ Examples

=PERCENTOF(data_subset,data_all)

Related functions

Copied to clipboard