I need to create a formula to calculate the percentage of the total for B4 using absolute and mixed cell references with the result in H4. I then need to copy the formula from H4 to I4:J4 to get the percentages for C4 and D4. After that I need to copy the formulas from H4:J4 to H5:J14. How do I do that?
B4 C4 D4 E4 (total of B4-D4)
31 68 77 176