Hi
I have a formula :
=sum (E106: E108)
i wish to copy this function to the cell below and add three rows i.e the formula should no read:
= sum (E109 : E 111)
i.e just as if i copied it dowm three rows.
Any ideas , I have many cells to copy down.
Thansk
Mark