Sum Values up to a blank row

[grezmel]

Hi,

Hope someone can help.

I am working in an xlt file.

Cell E19 is a sum of E11:E17, however the software I am using exports a list of items and weights into the spreadsheet leaves a blank and then adds a total.

Is there a way of automatically looking for the blank cell (bearing in mind the number of items will differ depending on the product exported) and cutting the total value and placing it 6 cells down - in this case E25, however E25 may become E26 and so on as the export expands the rows automatically.

Hope this makes sense.


excel2.jpg