Calculate the percentage average To find the average percentage of the two percentages in this example you need to first divide the sum of the two percentage numbers by. The excel formula for percentage is Portion Days Total Days 100. For example if you want.
The Function Arguments window will appear.
Label the data in row 1 of the spreadsheet. Averaging percentages isnt always straightforward. Release the mouse you can check the result now. To illustrate how each.