98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-courses - Filtering and subtotalling
microsoft-excel-courses - Filtering and subtotalling
Resolved · Low Priority · Version Standard
Cavell has attended:
Excel Advanced course
Filtering and subtotalling
How do you filter a list and then provide subtotal figures for selected criteria and display the subtotals on the sheet?
RE: Filtering and subtotalling
Hi Cavell
Thank you for your question - this is an interesting one.
Perhaps if you try applying subtotals first, then filtering afterwards, this might provide what you are looking for.
Otherwise you can set up an advanced filter (Data - Filter - Advanced filter) to apply the filter and choose to use the Copy to another location option to separate the filter result from the list/table of data; then apply subtotals to this.
I hope these suggestions help.
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:LARGE and SMALL functions and their usesTwo of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest? |