Summing Above Cell
There is an Excel file that teaches how to perform the Summing Above Cell operation.
Excel Source: Summing Above Cell
This workbook sums values above a selected cell using VBA across two example sheets with minimal two-row data layouts.
Hope it is useful.