Is there a way to get the sum of values in a column that excludes values in
hidden rows?

The sum should update itself as more rows are hidden/unhidden.

Thanks.