Hi i want the subtotals in my table to be posted to a different cell address not directly below or above the data i.e the data column is G20- g400 i want the subtotals to be posted to cell i5 going down. I got little VB experience i cannot seem to make xlsummaryrow present this data in the cell i want,Please any suggestions