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.
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.
Try
=sum(D10:D200)
It calculates the sum upto 200 cells starting from 10. If you want more you can add more
Yes I can do that. But I want to make it a dynamic formula so that I don't need to adjust it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks