PERCENTOF
Sums the values in the subset and divides it by all the values.
Math & TrigonometryMath BasicsModern Excel Functions
What it does
Calculates the sum of a subset divided by the total sum.
Syntax
PERCENTOF(subset_data, all_data)
Arguments
subset_data(range) — Subset.all_data(range) — Total.
Examples
Calculate Percentage
% of Sales from East.
FORMULA
=PERCENTOF(SUMIF(A:A,"East",B:B), SUM(B:B))
RESULT
0.25
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Region | Sales |
| 2 | East | 25 |
| 3 | West | 75 |