Question

what are the two ways to create subtotal in spreadsheet​

Answer 1

Answer:

How do you create a subtotal in Excel?

Insert subtotals

To sort the column that contains the data you want to group by, select that column, and then on the Data tab, in the Sort & Filter group, click Sort A to Z or Sort Z to A.

On the Data tab, in the Outline group, click Subtotal. ...

In the At each change in box, click the column to subtotal.

Answer 2

Answer:

To create a subtotal:

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.

Create Multi-Level Subtotals

1. Select any cell containing data. ...
2. Select the "Data" tab and then click the "Subtotal" command in the Outline group. ...
3. Click the drop-down menu under "At Each Change In," and then select the column you want to use for your first-level subtotals.
4. More items...