Excel's PERCENTOF function returns the percentage that a subset of data ... to create your data retrieval table in an area of your spreadsheet that isn't formatted as a table.