Forum Discussion
Unable to get cells with % Formulas to add up to100% but yet the Sum Total in the cell shows 100%
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 o...
Excel calculates 100 % correctly
Can you change the example so that your problem can be understood.
dscheikey Here is a quick view of the excel chart - The total % of Responses manually adds up to 99%