Use SUBTOTAL(9,range) instead of SUM(range). You can change the number
to get different effects, like COUNT and COUNTA - see Excel Help for
further details.
I put totals like this on the top row of the spreadsheet with the
header row (and filter pull-downs) below them. This way you can see
them easily when applying filters, rather than jumping down to the
bottom of the sheet each time.
Hope this helps.
Pete
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.