The most straightforward use of the PERCENTOF function is to calculate the percentage ... Because GROUPBY creates a dynamic array, the function won't work in a formatted Excel table.