In Sheet2 I have a list of payment records:

In Sheet2, I need A10 to find the last paid order in the cells above it (i.e. 1033), then sum up the next order (1034) till the last order (1038) from Sheet1

something like

B10=SUM(Sheet1!ROW(1034):Sheet1!LASTROW)

How do I do that?