Rewrite: =sum(c1:$c$10) 1) using r1c1 reference style in cell d1 2) using the offset function with cell a1 as the reference cell
a) =SUM(R1C3:R10C3)
b) =SUM(RC[-2]:RC[-2])
c) =SUM(R1C3:R[9]C3)
d) =SUM(R[-1]C:R[8]C)