In this article, we will learn about SUBTOTAL Formula in Excel. The function that returns a subtotal from a list or database can be defined as the Subtotal function. Subtotal is a special function among other Excel functions because it can perform multiple operations, unlike other Excel func...
Returns a subtotal in a database or list, i.e., finding out the subtotal of a given range of cells. It performs a specified calculation for a given set of values. SUBTOTAL Formula in Excel The formula for the SUBTOTAL function is as follows: ...
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...
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.
With that, let’s look into some more examples of the SUBTOTAL function to better understand how it works in Excel. SUBTOTAL formula example #1 Let’s see a quick example of using the 101-111 function number series of the SUBTOTAL function. ...
3. Using the SUM Function to Calculate the Subtotal Choose a cell to see the subtotal. Enter the following formula: =SUM(F5:F16)/2 PressEnterto calculate the subtotal ofProduct A. Click the image for a detailed view. How to Add Multiple Subtotals in Excel ...
= SUBTOTAL ( 3, B2:B14)As you can see the total rows which are visible comes out to be 11. Now we will use one more example to extract the Average of the quantity which are visible or filtered.Use the formula:= SUBTOTAL ( 1 , C2:C14 )...
Use the SUBTOTAL function in Excel (instead of SUM, COUNT, MAX, etc.) to ignore rows hidden by a filter or to ignore manually hidden rows.
You can create a formula using the Excel SUBTOTAL function with the flexibility to include or exclude rows you've hidden. The syntax for the formula is SUBTOTAL(function_number, reference 1, reference 2,...) where the first two arguments are required. You can use additional cell references...
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.