Excel Tutorial: Subtotal

 

 

Let's check this out.

Step: 1

Before insert Subtotal, you need to sort the list so that the rows you want to subtotal are group together.

Step: 2

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

Step: 3

Now, in each change in box, click the column that contains the group for which you want subtotal, then click OK.

Step: 4

Check your result now.

By Ee LeeLing   | Google  | LinkedIn

Cempaka Technology Sdn Bhd

Pusat Latihan Komputer Cempaka
~Your HRDC Premiere Training Provider~
64-2, Jalan Puteri 2/2, Bandar Puteri Puchong, 47100 Puchong Selangor, Malaysia. Tel: 603-80684461
1-28, Jalan PM4, Plaza Mahkota, 75000 Melaka. Tel: 606-2835955
Instant SSL