To use the SUBTOTAL function, create a formula using the syntax: SUBTOTAL(function_number, reference 1, reference 2,…). You can also use the Subtotal feature by selecting your rows, then clicking the “Data” tab. In the Outline drop-down menu, select “Subtotal.”
Obtaining subtotals for groups of related items is easy in Microsoft Excel. In fact, you have two ways to do this. You can either use the SUBTOTAL function or the Subtotal feature, whichever works best. We’ll show you how.
What Is a Subtotal in Excel?
As mentioned, SUBTOTAL in Excel allows you to group the same or related items in a list and use a function to calculate the values. For example, you can use it to sum sales by month or average grades by student. You could also add inventory by product or count the number of bills due next week.
RELATED: How to Use the COUNT Function in Microsoft Excel
Using the SUBTOTAL function by creating a formula or using the Subtotal feature, you can get the calculations you need in just a few steps.
Use the Excel SUBTOTAL Function
You can create a…
Read Full Article Source
