if you have nothing below the data, couldnt you just use.....

=SUM(GDD!E27:GDD!E1000)