How to Use Excel's SUBTOTAL Function

[CrazeD]

Can nay one tell me how to use Excel's SUBTOTAL Function, i know the Subtotal function is use to calculate the value of number which are inserted in to row and column of excel sheet but i need to know the exact use of Subtotal function and where to declare it?

[Macarenas]

In Excel, the Subtotal function returns the subtotal of the numbers in a column in a list or database. The Excel Subtotals command allows you to quickly summarize a data set.Data Subtotals is another powerful tool available in Excel to make designing and using spreadsheets easy and accurate. Subtotal is normally used only to modify an existing list because the Subtotals command from the Data menu can usually create the list more easily.

[vishodhan]

You can use the Data - Subtotals command in excel to automatically subtotal a range of data. The syntax for the Subtotal function is: Subtotal( method, range1, range2,range3, range4 ... range_n ). Method which is declare in front of the range iis use to declare the method type like maximum or minimum, average.

[JonathanD]

You can use the SUBTOTAL function to dynamically count or display other information about records in a list that has AutoFilter turned on. When you change the AutoFilter criteria, the results of the SUBTOTAL function also change. In the Subtotal dialog box, you can choose the column on which to base your subtotals (such as every change of value in the employee column), the summary calculation that you want to perform, and the column or columns with values to be summarized.