Filter Subtotal in Excel

Excel - How to use the Subtotal Function with Filters

We love to use Filters in Excel. When filtering data, the filtered rows turn blue. To get the SUM, AVERAGE, MAX, MIN, or COUNT of the filtered data, use the SUBTOTAL function. If you use one of the functions with one argument - SUM, AVERAGE, MAX, MIN, or COUNT - you'll end up with the incorrect answer. For example, when filtering data and you ...

44.6K viewsOct 22, 2021

Excel Filter Tutorial

16:22

How to Filter in Excel

YouTubeKevin Stratvert

524.7K viewsMay 31, 2020

10:46

Excel Filter Basics (for quick data analysis)

YouTubeLeila Gharani

348.6K viewsMar 1, 2018

6:23

How to APPLY FILTER in Excel STEP BY STEP

YouTubeExcel at Work

8.2K views9 months ago

Top videos

5:48

Excel Filters with the SUBTOTAL Function

YouTubeChris Menard

16.4K viewsSep 14, 2023

1:26

Using Excel's Subtotal Function with Filters in Excel

YouTubeChris Menard

170.9K viewsSep 13, 2013

1:49

Excel - Find Out How To Add Subtotals To Your Filtered Data In Excel! Episode 2563

YouTubeMrExcel.com

8.7K viewsFeb 28, 2023

Excel Advanced Filter

7:18

How to Use the Advanced Filter in Microsoft Excel

YouTubeSimon Sez IT

56.8K viewsMay 26, 2022

1:22

How to use Advanced Filter in Excel | Excel Tricks

YouTubeMicrosoft Office Tutorials

136.1K viewsSep 30, 2023

10:25

Advanced Filter in Excel - Explained with Easy Examples

YouTubeTrumpExcel

199.5K viewsAug 30, 2015

5:48

Excel Filters with the SUBTOTAL Function

16.4K viewsSep 14, 2023

YouTubeChris Menard

1:26

Find in video from 0:00Introduction to Filters

Using Excel's Subtotal Function with Filters in Excel

170.9K viewsSep 13, 2013

YouTubeChris Menard

1:49

Find in video from 00:39Removing Filters

Excel - Find Out How To Add Subtotals To Your Filtered Data In …

8.7K viewsFeb 28, 2023

YouTubeMrExcel.com

Calculate Total in Filtered Data in Excel | SUBTOTAL Function Tutorial

2:34

Find in video from 00:31Applying Data Filter

Calculate Total in Filtered Data in Excel | SUBTOTAL Function Tutorial

23.1K viewsJul 2, 2024

YouTubeSpreadsheet Tutorials

Get the Sum of Filtered Data in Excel (Using SUBTOTAL Formula)

2:32

Find in video from 00:25Filtering Data

Get the Sum of Filtered Data in Excel (Using SUBTOTAL Formula)

376.4K viewsOct 1, 2019

YouTubeTrumpExcel

Excel Lesson: Subtotals, Sort, and Filter

8:34

Find in video from 0:00Introduction to Subtotals, Sort, and Filter

Excel Lesson: Subtotals, Sort, and Filter

12.7K viewsJan 25, 2019

YouTubeMike's Office

1:00

Using Subtotal Function and Filter in Excel | Tutor Joes

1.3K viewsApr 24, 2023

YouTubeLEARN ALL IN TAMIL

9:12

Find in video from 01:14Understanding Filtering in Excel

Summarize filtered values in Excel with SUBTOTAL & AGGREGATE F…

10.9K viewsAug 25, 2015

YouTubeChandoo

2:59

Find in video from 00:13Setting Up the Filter

Excel - Numbering Visible Rows in Filtered List (with SUBTOTAL Fun…

38.8K viewsAug 31, 2022

YouTubeMrExcel.com

0:28

Excel Totals Wrong After Filter? Fix It Instantly with SUBTOTAL!

2.5K views1 month ago

YouTubeEasy Click Learning

2:58

Sum Filtered Data in Excel with SUBTOTAL (The Right Way!)

315 views4 months ago

YouTubeEasy Click Learning

0:37

Calculation in Filtered Data in Excel

338 viewsAug 12, 2024

YouTubeSpreadsheet Tutorials

4:38

How to use Filter Function in Microsoft Excel | Filter Formula in …

49.3K views8 months ago

YouTubeStudySpan

4:57

Find in video from 00:02Introduction to Excel Subtotal Function

Using the Excel SUBTOTAL Function

281.7K viewsJul 3, 2023

YouTubeTechnology for Teachers and Students

7:07

Find in video from 0:00Introduction to Filtering Data

3 Ways to Filter Data in Excel

107.5K viewsFeb 8, 2024

YouTubeTeacher's Tech

0:55

Find in video from 0:00Introduction to Subtotal Formula

Subtotal formula shortcut trick | Sum only filtered values in Excel #…

20.8K viewsSep 2, 2021

YouTubeLearnYouAndMe

17:15

Find in video from 12:00Adding Filtering to Subtotals

Using Sumproduct Function In Excel To Subtotal Filtered Data

23.6K viewsApr 10, 2018

YouTubeGlenEClarkeTraining

8:08

Find in video from 0:00Introduction to Subtotal Function

How To Use The Subtotal Feature And Subtotal Function In Excel

372.1K viewsJul 2, 2020

YouTubeExcel Campus - Jon

0:23

How to Sum Only Colored Cells in Excel Using SUBTOTAL & Filter!

751 views10 months ago

YouTubeSpreadsheet Success

4:10

Find in video from 0:00Introduction to Subtotals

MS Excel - Subtotal

697.6K viewsJan 15, 2018

YouTubeTutorialsPoint

5:45

How to Create Subtotal in Microsoft Excel Part-II

276.2K viewsJul 29, 2020

YouTubeStudySpan

9:49

Find in video from 00:01Introduction to Subtotal Formula

Subtotal Formula in Excel

74.4K viewsAug 25, 2011

YouTubeMy E-Lesson

6:16

How to use SUBTOTAL Formula in Microsoft Excel | SUBTOTAL Func…

15.6K views7 months ago

YouTubeStudySpan

10:46

Find in video from 0:00Introduction to Excel Filter Options

Excel Filter Basics (for quick data analysis)

349.3K viewsMar 1, 2018

YouTubeLeila Gharani

0:46

Sum with Filter: Accurate totals even with filtered data in Excel?

84.9K viewsOct 21, 2024

YouTubeExcel Campus - Jon

0:57

SUBTOTAL Formula in Excel Explained in 60 Seconds! 🔥 | Excel …

1.1K views6 months ago

YouTubeAdvancement

7:04

Sum Formula that Updates Automatically when you Filter Dat…

525 views3 months ago

YouTubeJopa Excel

0:24

SUBTOTAL Function in Excel | Advanced Data Analysis

74 views9 months ago

YouTubeComputer Skills

0:49

Find in video from 0:00Introduction to Subtotal Function

Master EXCEL Subtotal Function Like a Pro!

4K viewsOct 18, 2024

YouTubeBright Minds Hub

See more videos

Top suggestions for Filter Subtotal in Excel