Microsoft Office Tutorials and References
In Depth Information
Chapter 25: Excel Subtotals
FIGURE 25.1 The Data on the Sheet Database in the Excel File Chapter 25
FIGURE 25.2 Data Sorted by Gender
Check the appropriate box to indicate which columns or data you wish to apply
the Average function to. In our example, select the Age. You could have asked
for the Seniority as well. I just chose the age.
You can see the subtotals created in Figure 25.4. The averages are for the
grouped data for females and males.