Excel Forum
Similar Content
MAX and MIN Values from a Filtered List in Excel
Tutorial: How to get the MAX and MIN values from a filtered data set. This method returns the value ...
Count the Visible Rows in a Filtered List in Excel
Tutorial: How to use the COUNT function on a filtered list of data so that hidden rows are not incl...
Enable the Analysis ToolPak in Excel
Tutorial: How to enable the Analysis ToolPak in Excel. This is an add-in program that comes with Exc...



Excel Basics #19: Data Analysis Subtotals


The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#19 Video topics:
1)Subtotals
2)See how to sort first and then do Subtotals
3)Major Key Field Subtotals first and then secondary field with the Replace Current Subtotals unchecked
4)Excel List Table Database format is required for Subtotals
5)Data Subtotals Sub Totals





Got a Question? Ask it Here in the Forum.