you could try something along the lines of:
=SUM(INDEX($D$3:$Z$5,0,ROW()-13))
but the 13 in there is because the topmost cell my formula was in was on row 14.
You need to adjust the 13 to the row the topmost formula is in minus 1, then copy down.