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   | LinkedIn

Cempaka Technology Sdn Bhd

Pusat Latihan Komputer Cempaka
~Your HRDC Premiere Training Provider~
Unit 6, Level 4, SetiaWalk Mall (Block K), SetiaWalk, Persiaran Wawasan, Pusat Bandar Puchong, 47160 Puchong, Selangor, Malaysia.
Tel: 603-80684461, Fax: 603-80684240
1-28, Jalan PM4, Plaza Mahkota, 75000 Melaka, Malaysia
Tel: 606-2835955, Fax: 606-2845955