Example Column Cell K5=SUM(C5,E5,G5,I5)

Then all of Column K is added up with the following formula K31 =SUM(K5:K30)  

Column L, rows 5 thru 30 are a % of the rows Total (Cell K31) or the formula of Cell K31 =SUM(K5:K30)

Cell L5=K5/K31 to get a % or 24%   This is duplicated for Cells L6 through L30 for a total of 100% in cell L31 but the actual total of the column is only 99%.    How can this be corrected so that the numbers are accurate and don’t need to manually add to see if the total is correct.   I have had to do manual adjustments to make the numbers add up to the 100%.   Your assistance is greatly appreciated.

​Example Column Cell K5=SUM(C5,E5,G5,I5)Then all of Column K is added up with the following formula K31 =SUM(K5:K30)  Column L, rows 5 thru 30 are a % of the rows Total (Cell K31) or the formula of Cell K31 =SUM(K5:K30)Cell L5=K5/K31 to get a % or 24%   This is duplicated for Cells L6 through L30 for a total of 100% in cell L31 but the actual total of the column is only 99%.    How can this be corrected so that the numbers are accurate and don’t need to manually add to see if the total is correct.   I have had to do manual adjustments to make the numbers add up to the 100%.   Your assistance is greatly appreciated.      Read More

​