Question

subtotal in excel
please written the correct answer ​

Answer 1

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.

Answer 2

Answer:

How to do subtotal formula in Excel?

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.

Explanation:

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.