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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement