I need to use a formula like sum(c1.c5)/r[4]c[-1].

Since as and when I add any rows between row 1 & 5 the formula should
automatically change to sum(c1.c6) but the cell as a divison should always be
the value in the cell 4 rows down in B column.