Formula to sum a variable column range

[TIERNAN]

I have data in D10:D15 and I have a sum formula in D9. I want my formula to update when I add data in D16 onwards without having to amend the original formula.

All the help that I receive is much appreciated.

[kishoremcp]

Try
=sum(D10:D200)
It calculates the sum upto 200 cells starting from 10. If you want more you can add more

[TIERNAN]

Yes I can do that. But I want to make it a dynamic formula so that I don't need to adjust it.