If you surround your list with blank rows and columns, the Subtotals command (Data menu) will select the correct data to ...