I've found that the SUBTOTAL function is useful because it works with filtered data, ignoring filtered values. So far, it looks like this:

=SUBTOTAL(9, Tbl_AreaCover[Area 1])

I need to replace [Area 1], which is a fixed column of the Tbl_AreaCover table, with a value selected in a cell, so that the formula is dynamic. Any suggestions? TIA.