Enter =subtotal( 109, sum area) at the bottom, and 109 represents the sum of the visible areas.

Enter = in a cell in another table, and then click the cell you just summed to refer to it.