In this tutorial we’ll take a look at the SUBTOTAL function in Excel and see how each of the 22 options available with this function work.
You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.
Here I have a list of values. Notice the hidden rows:
We are going to apply the 22 different function options of the SUBTOTAL function to this list. The syntax for the subtotal function is:
=SUBTOTAL(function_num, ref1, ref2, …)
Basically you enter the function you want to use, then the range of values you want to apply that function to. There are 22 different functions, 11 that will apply the function to values that include ones that are hidden, and 11 that will ignore the hidden values. Those function numbers are:
A brief explanation of each function is as follows:
And the answers along with the related formulas are listed here:
So, basically the SUBTOTAL function is very straight forward and easy to use. Just decide if you want to include the hidden values or not, determine what application you want to apply to those values, enter the appropriate function number and your range of values, and SUBTOTAL will give you the answer!
What can you do next?
Share this post with others that can benefit from it!
Leave a comment or reply below – let me know what you think!
Subscribe to this blog for more great tips in the future!
Check out my YouTube channel – click on the YouTube icon below!