Thursday, November 17, 2011

How to Add Subtotals in Excel


1. Create the list of numbers to be added. Make sure to label the top of each column with a heading.
2. Highlight the column of numbers to be added by clicking on the number at the top of the column. Once all of the data is outlined and highlighted in blue, the numbers are ready to be added.
3. Go to the 'Data' tab at the top of the Excel toolbar.
4. Select 'Subtotal' from the 'Outline' section, which is on the far right side of the toolbar.
5. Confirm the column being added. Make sure that the function is set to 'Sum.' If it isn't, select 'Sum' from the 'Use Function' drop-down menu. Click 'OK' at the bottom off the confirmation screen to add the subtotals.

Blogger news