The Microsoft Excel SUBTOTAL function returns the subtotal of the numbers in a column in a list or database. The SUBTOTAL function is a built-in function in Excel that is categorized as a Math/Trig Function.
It can be used as a worksheet function in Excel. The Subtotal command allows you to automatically create groups and use common functions like SUM, COUNT, and AVERAGE to help summarize your data.
To create a subtotal, do the following:-
1. First, sort your worksheet by the data you want to subtotal.
2. Select the Data tab, then click the Subtotal command.
3. The Subtotal dialog box will appear.
4. Click the drop-down arrow for the Use function: field to select the function you want to use. Eg. Sum, count etc.
5. When we're satisfied with your selections, click OK. When we create subtotals, our worksheet it is divided into different levels.
0 Comments:
Post a Comment