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...
Average the Visible Rows in a Filtered List in Excel
Tutorial: Average the results from a filtered list in Excel. This method averages only the visible ...



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.