Wed 23 Sep 2009, 16:14Delegate Roy said...
Roy has attended:
Excel Advanced course
Sub totaling
When Subtotalling - How do I quicky subtotal those rows
Fri 25 Sep 2009, 13:10Trainer Andrew said...
RE: sub totaling
Hi Roy
Thank you for your question.
You can quickly add subtotals by clicking in your table of data, sorting the column you would like to subtotal then from the Data menu choose Subtotals.
In the dialog box choose the type of function to apply (eg Sum) and the coumns below which you wish to add totals then click on OK
I hope this helps - do let us now if you have any further questions.
Kind regards,
Andrew
