Resources

Helpful (hopefully) technology tips

An Example of Using the Subtotal Function in Excel

The SUBTOTAL function is incredibly versatile, and the name is misleading since it can perform any of 11 different calculations not just finding totals.  The particular calculation is controlled by using a specific value for one of the arguments, which we will describe below. There are two main reasons why the SUBTOTAL function is so [...]

By |2021-12-13T13:38:39-07:00December 13th, 2021|Data Analysis, Excel, MS Office 2016|0 Comments

An Example of Using the Subtotal Command in Excel

In the previous article we discussed the SUBTOTAL function https://windsongtraining.ca/an-example-of-using-the-subtotal-function-in-excel/ https://windsongtraining.ca/an-example-of-us…unction-in-excel/‎. In this post we will look at the SUBTOTAL command found on the Data tab in the Outline group.  Each Excel function provides a specific calculation.  We use any of the over 500 functions that Excel provides by typing an = sign in a cell [...]

Go to Top