Excel Data Tab: SUBTOTAL in Detail | How to use SUBTOTAL Feature & SUBTOTAL Function in Excel
#ayushtipsntrick #Excel #subtotal
Watch the latest Video by Clicking : https://goo.gl/fULP6f
Link to my Channel : / ayushtipsntrick
Subscribe to my channel : https://goo.gl/nHpNE4
In this video, discover the difference between the SUBTOTAL function and the Subtotal feature in Excel and learn how to use both to insert subtotals in your data.
SUBTOTAL FUNCTION / FORMULA is very powerful and most ever useful feature of excel which work only on visible data. The Subtotal feature adds subtotal and grand total rows to a data set to convert data to a summary report. It also adds row groups that can be expanded and collapsed to just view the subtotal rows. When the rows are hidden or collapsed, the formulas will still display the correct results because they use the 1-11 function (such as SUM COUNT COUNTA AVERAGE, MAX, MIN, Std Deviation, etc.) numbers in the first argument of the SUBTOTAL function. The SUBTOTAL function also excludes any other cells with SUBTOTAL formulas that are in the formula's reference range. This means that the subtotals do NOT get double counted. This makes it easier to use than the SUM function for creating total and subtotal rows.
Watch the video and Learn how to use Subtotal feature of Excel step by step.
1.Subtotal using Sum Formula
2. Subtotal Manual method
3. Why we use subtotal in excel
This subtotal formula will work in all excel versions 2007 2010 2013 2016 2019, office 365.