Forum Discussion
Function for finding percentage of sum
What function do I use and how do I write it when trying to find the percentage of: (A10+A11)/5?
This sounds like the forthcoming PERCENTOF function. It's currently only available on the Insider's channel:
PERCENTOF function - Microsoft Support
From the article:
Note: PERCENTOF is logically equivalent to =SUM(data_subset)/SUM(data_all)