Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How To Use The Subtotal Function In Microsoft Excel

Date:2021-7-26 Author:Sandra

Have you used the Subtotals function in Excel ever before? This can help you sort and sum data quickly. If you always handle tables or Excel worksheets. This is a really great command. Let’s take a simple example.

How To Use The Subtotal Function In Microsoft Excel

Go to the Data and click on Subtotal.

How To Use The Subtotal Function In Microsoft Excel

At each change in Sales Departments and add subtotal to sales volume, then hit OK.

How To Use The Subtotal Function In Microsoft Excel

Now the table is divided into sections according to different departments.

You can also divide the table into sections according to different Salesmen.

How To Use The Subtotal Function In Microsoft Excel

It’s very easy to use the subtotal command. You can display more than one type of summary function for each column.

How To Use The Subtotal Function In Microsoft Excel
How To Use The Subtotal Function In Microsoft Excel

That’s all for today’s sharing. See you next time~

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *