PERCENTOF
Returns the percentage that a subset of data represents from the full data set
Syntax
PERCENTOF(data_subset, data_all)
Parameters
- data_subset: Required. The numerical data that is a subset of data_all
- data_all: Required. The array or range of data that is considered the full data set
Example
=PERCENTOF(FILTER(B2:B10, A2:A10="East"), B2:B10)