Input cell should display a percentage of input value in the cell

[Sherees]

Please read the below discussion and suggest an answer

Many thanks for ur answer
what if i want to change B1:B700(but want to leave one cell for sum total in
every 8 cells down), similarly in C1:C700, & D1: D700