Kim,
You can autofilter on all the columns and turn them on as needed.

I use subtotal that sums only the visible rows

Add you subtotal a couple of rows below your last row of data. The click on your filters.

snip from help
SUBTOTAL will ignore any hidden rows that result from a list being filtered. This is important when you want to subtotal only the visible data that results from a list that you have filtered.

hth MikeD