Q-8 How to perform Subtotal in Excel? Give an example.
Answers
Answered by
4
Explanation:
To create a subtotal:
First, sort your worksheet by the data you want to subtotal. ...
Select the Data tab, then click the Subtotal command. ...
The Subtotal dialog box will appear. ...
Click the drop-down arrow for the Use function: field to select the function you want to use.
please mark me as brainlist
Answered by
2
Explanation:
To create a subtotal:
- In our example, we will use the Subtotal command with a T-shirt order form to determine how many T-shirts were ordered in each size (Small, Medium, Large, and X-Large). This will create an outline for our worksheet with a group for each T-shirt size and then count the total number of shirts in each group.
- First, sort your worksheet by the data you want to subtotal. In this example, we will create a subtotal for each T-shirt size, so our worksheet has been sorted by T-shirt size from smallest to largest.
- Select the Data tab, then click the Subtotal command.
- The Subtotal dialog box will appear. Click the drop-down arrow for the At each change in: field to select the column you want to subtotal. In our example, we'll select T-Shirt Size.
- Click the drop-down arrow for the Use function: field to select the function you want to use. In our example, we'll select COUNT to count the number of shirts ordered in each size.
- In the Add subtotal to: field, select the column where you want the calculated subtotal to appear. In our example, we'll select T-Shirt Size.
- When you're satisfied with your selections, click OK.
- The worksheet will be outlined into groups, and the subtotal will be listed below each group. In our example, the data is now grouped by T-shirt size, and the number of shirts ordered in that size appears below each group.
Attachments:
![](https://hi-static.z-dn.net/files/dc9/216c0d68426979206fab434079ff08a5.jpg)
![](https://hi-static.z-dn.net/files/dbd/572b32cacbec5d1a76b0a0c995ea969b.jpg)
Similar questions
Political Science,
4 months ago
Math,
4 months ago
Chemistry,
9 months ago
Computer Science,
1 year ago
Math,
1 year ago
Chemistry,
1 year ago