The SUBTOTAL function in Microsoft Excel returns the subtotal value from a range of cells. Learn how to use it in this step-by-step tutorial.
In this article, we showed how to use the Excel SUBTOTAL function. We used easier methods and included images to make them understandable.
Usingthe COUNTA functioninsidethe SUBTOTAL functioninExcelis to count all the cells that have any type of data. Let us see this in practice. Steps: Go to cellC10and insert the following formula: =SUBTOTAL(3,C5:C9) PressEnterto calculate the total different item types inside cellC10. Meth...
In this article, we will learn How to use the SUBTOTAL function in Excel.Obtain results on filtered rowsThe biggest problem with SUM, AVERAGE, COUNT and other NUMBER functions is, that they include rows that are hidden by filter. They don’t work correctly when we want to sum, count, ...
Subtotal function in Excel is a wonderful formula that can be used to perform some specific arithmetic and logical operation on a defined range of cells.
=SUBTOTAL(1,C2:C6) And next, we'll exclude the hidden rows with this formula: =SUBTOTAL(101,C2:C6) Notes on the SUBTOTAL Function Here are a few things to keep in mind when using the SUBTOTAL function in Excel: The function works for columns or vertical ranges, not rows or horizon...
Note that Excel has only added up the filtered values i.e. $2000 and $500. The unfiltered values are not included in the SUM. Why use SUBTOTAL? The SUBTOTAL function is a very well-thought and smart function. Here are some reasons why the SUBTOTAL function must be used: ...
We will see a few examples to understand how the subtotal function will work for different function numbers. How to Use SUBTOTAL Formula in Excel? SUBTOTAL Formula in Excel is very simple and easy. Let’s understand how to use the SUBTOTAL Formula in Excel with some examples. ...
Go to the "Home" tab, and in the "Editing" group, click on the "AutoSum" button. Excel will automatically insert the SUBTOTAL function and pick the visible numbers within your column. Press "Enter" to sum only the visible numbers. Conditional...
This Excel tutorial explains how to use the Excel SUBTOTAL function with syntax and examples. The Microsoft Excel SUBTOTAL function returns the subtotal of the numbers in a column in a list or database.