microsoft-excel-courses - Filtering and subtotalling

Resolved · Low Priority · Version Standard

Filtering and subtotalling

Cavell has attended:
Excel Advanced course

by - delegate Cavell [1 post] (2008 Jan 24 Thu, 14:03) Reply

How do you filter a list and then provide subtotal figures for selected criteria and display the subtotals on the sheet?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	2	book now	£495	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	3	book now	£525	£545
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Jan 22 Thu + 23 Fri	Southwark	4	book now	£475	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Filtering and subtotalling

by - trainer Amanda diamond contributer [1243 posts] (2008 Feb 6 Wed, 21:03) Reply

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

· Interesting Lifestyle Applications for Microsoft Excel
· Training Budgets In A Bad Economy
· Identifying Suitable Candidates For VBA For Excel Training
· Reporting and Analysis with Excel
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips

Rate this page: