Write the steps t insert subtotal values in spreadsheet.
Answers
Answered by
4
Subtotals are calculated with a summary function, such as Sum or Average, by using the SUBTOTAL function. You can display more than one type of summary function for each column.
Answered by
4
Answer:
- On the data tab, in the outline group, click subtotal. The subtotal dialog box displayed.
- In the At each change in box, click the nested subtotal column....
- In the use function box, click the summary function that you want to use to calculate the subtoatals...
- Clear the Replace current subtotals check box...
Explanation:
Hope its helpful♡...
Similar questions