Many Excel users will sort a specific column and insert empty rows within the table of data and insert the SUM formula to create subtotals. This is perfectly okay if the table only has few rows.  Imagine if you have thousands of rows.  Use the Subtotal command. The Subtotal tool in the Outline group on the Data tab of the ribbon automatically inserts subtotal formulas and grand totals for a column or columns. The subtotals can be SUM’s, AVERAGE’s, COUNT’s, MIN, MAX and more. Click on the following word document for a thorough explanation written by

by MYNDA TREACY on FEBRUARY 4, 2011
in EXCEL,MICROSOFT OFFICE TRAINING,ONLINE TRAINING

http://sdrv.ms/QDgQOM

Advertisements