Logo
HOW TO
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
 
 
Windows 7

Microsoft Excel 2010 : Subtotaling by Multiple Columns

12/3/2013 3:16:03 AM

To add subtotals based on multiple columns, as shown in Figure 1, sort the dataset by the desired columns and then apply the subtotals, making sure Replace Current Subtotals is not selected. The subtotals should be applied in order of greatest to least. For example, if the data is sorted by Region, with the products within each region sorted, apply the subtotal to the Region column and then the Product column.

Figure 1. Apply subtotals to Region (the major column) and then Product (the secondary column) to get subtotals of both.

Subtotaling by Multiple Columns

To subtotal by multiple columns, as shown in Figure 1, follow these steps:

1.
Sort the data by the columns the summary should be based on.

2.
Select a cell in the dataset.

3.
Go to Data, Outline, Subtotal.

4.
From the At Each Change In field, select the major column by which to summarize the data.

5.
From the Use Function field, select the function to calculate the totals by.

6.
From the Add Subtotal To field, select the columns the totals should be added to.

7.
Click OK.

8.
Repeat steps 3 to 7 for the secondary column.
Other -----------------
- Microsoft Excel 2010 : Formatting Subtotals, Applying Multiple Subtotal Function Types (part 2) - Combining Multiple Subtotals to One Row
- Microsoft Excel 2010 : Formatting Subtotals, Applying Multiple Subtotal Function Types (part 1)
- Microsoft Excel 2010 : Expanding and Collapsing Subtotals, Copying Subtotals
- Microsoft Excel 2010 : SUBTOTAL Function, Subtotal Tool
- Microsoft PowerPoint 2010 : Managing Slides (part 2) - Rearranging Slides
- Microsoft PowerPoint 2010 : Managing Slides (part 1) - Undoing Mistakes
- Microsoft PowerPoint 2010 : Inserting Content from External Sources - Inserting New Slides from an Outline
- Microsoft PowerPoint 2010 : Creating New Slides (part 2) - Creating a Slide from a Layout, Copying Slides
- Microsoft PowerPoint 2010 : Creating New Slides (part 1) - Creating New Slides from the Outline Pane
- Mix and Match with Old Windows and Macs : Installing Optional Network Components
 
 
REVIEW
- First look: Apple Watch

- 10 Amazing Tools You Should Be Using with Dropbox
 
VIDEO TUTORIAL
- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 1)

- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 2)

- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 3)
 
Popular tags
Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 Adobe Indesign Adobe Flash Professional Dreamweaver Adobe Illustrator Adobe After Effects Adobe Photoshop Adobe Fireworks Adobe Flash Catalyst Corel Painter X CorelDRAW X5 CorelDraw 10 QuarkXPress 8 windows Phone 7 windows Phone 8 BlackBerry Android Ipad Iphone iOS
Popular keywords
HOW TO Swimlane in Visio Visio sort key Pen and Touch Creating groups in Windows Server Raid in Windows Server Exchange 2010 maintenance Exchange server mail enabled groups Debugging Tools Collaborating
Top 10
- Microsoft Excel : How to Use the VLookUp Function
- Fix and Tweak Graphics and Video (part 3) : How to Fix : My Screen Is Sluggish - Adjust Hardware Acceleration
- Fix and Tweak Graphics and Video (part 2) : How to Fix : Text on My Screen Is Too Small
- Fix and Tweak Graphics and Video (part 1) : How to Fix : Adjust the Resolution
- Windows Phone 8 Apps : Camera (part 4) - Adjusting Video Settings, Using the Video Light
- Windows Phone 8 Apps : Camera (part 3) - Using the Front Camera, Activating Video Mode
- Windows Phone 8 Apps : Camera (part 2) - Controlling the Camera’s Flash, Changing the Camera’s Behavior with Lenses
- Windows Phone 8 Apps : Camera (part 1) - Adjusting Photo Settings
- MDT's Client Wizard : Package Properties
- MDT's Client Wizard : Driver Properties
 
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
2015 Camaro