For example to find percent of total for following numbers. A1A5 Percentage formatting is applied to Columns B and C. Says to do the sum of Import and Export on a row by row basis ie.
C6 C11 In cell D6 the result of the calculation is 625.
255 divided by 106 6 sales tax 24057 rounded up 1443 tax amount to report. Your of total then just becomes. Here the total number of vacations is 15 days. Use the formula C2B2 in column D to calculate the what percentage of the number in column B is represented by the number in column C.