So long as you have properly used the $ as I have to only anchor column D as absolute, the formula should apply properly even if it doesn't reflect it in the dialog.

If you have a question as to whether it's working, test it out by changing some of the values in D in the lower rows.