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.1K viewsOct 22, 2021

Excel Filter Basics

10:46

Excel Filter Basics (for quick data analysis)

YouTubeLeila Gharani

343.9K viewsMar 1, 2018

8:05

Filtering in Excel: Basics and Beyond

YouTubeTechnology for Teachers and

48.8K viewsDec 6, 2021

6:23

How to APPLY FILTER in Excel STEP BY STEP

YouTubeExcel at Work

4.9K views8 months ago

Top videos

2:34

Calculate Total in Filtered Data in Excel | SUBTOTAL Function Tutorial

YouTubeSpreadsheet Tutorials

22.9K viewsJul 2, 2024

1:26

Using Excel's Subtotal Function with Filters in Excel

YouTubeChris Menard

170.7K viewsSep 13, 2013

5:48

Excel Filters with the SUBTOTAL Function

YouTubeChris Menard

10.6K viewsSep 14, 2023

Excel Advanced Filter

7:18

How to Use the Advanced Filter in Microsoft Excel

YouTubeSimon Sez IT

55.4K viewsMay 26, 2022

1:22

How to use Advanced Filter in Excel | Excel Tricks

YouTubeMicrosoft Office Tutorials

129.9K viewsSep 30, 2023

5:20

How to use the advanced filter in Excel

YouTubeBarb Henderson

12.9K viewsMay 14, 2023

2:34

Find in video from 00:31Applying Data Filter

Calculate Total in Filtered Data in Excel | SUBTOTAL Function Tutorial

22.9K viewsJul 2, 2024

YouTubeSpreadsheet Tutorials

1:26

Find in video from 0:00Introduction to Filters

Using Excel's Subtotal Function with Filters in Excel

170.7K viewsSep 13, 2013

YouTubeChris Menard

5:48

Excel Filters with the SUBTOTAL Function

10.6K viewsSep 14, 2023

YouTubeChris Menard

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)

374.5K 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.5K viewsJan 25, 2019

YouTubeMike's Office

2:58

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

1 views3 months ago

YouTubeEasy Click Learning

3:37

SUBTOTAL Function in Excel – Dynamic Totals with Filters

2 views1 month ago

YouTubeFinance Buddy - Shivdatta

0:24

SUBTOTAL Function in Excel | Advanced Data Analysis

73 views8 months ago

YouTubeComputer Skills

17:15

Find in video from 12:00Adding Filtering to Subtotals

Using Sumproduct Function In Excel To Subtotal Filtered Data

23.5K 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

369.3K viewsJul 2, 2020

YouTubeExcel Campus - Jon

7:07

Find in video from 0:00Introduction to Filtering Data

3 Ways to Filter Data in Excel

97.7K viewsFeb 8, 2024

YouTubeTeacher's Tech

3:05

Find in video from 00:34Differences between SUM and SUBTOTAL when Filtering a List

Sum Filtered Excel Table with AGGREGATE or SUBTOTAL

144K viewsMay 17, 2013

YouTubeContextures Inc.

0:55

Find in video from 00:20Filtering Year 2020

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

20.8K viewsSep 2, 2021

YouTubeLearnYouAndMe

4:57

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

Using the Excel SUBTOTAL Function

274K viewsJul 3, 2023

YouTubeTechnology for Teachers and Students

4:10

Find in video from 0:00Introduction to Subtotals

MS Excel - Subtotal

690.7K viewsJan 15, 2018

YouTubeTutorialsPoint

0:46

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

80K viewsOct 21, 2024

YouTubeExcel Campus - Jon

6:16

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

15.4K views6 months ago

YouTubeStudySpan

5:45

How to Create Subtotal in Microsoft Excel Part-II

270.8K viewsJul 29, 2020

YouTubeStudySpan

2:40

Find in video from 0:00Introduction to Subtotal Formula

SUBTOTAL Formula in Excel (How & When to use)

35.4K viewsApr 12, 2019

YouTubeYoda Learning Academy

7:29

How to Create Subtotal in Microsoft Excel Part-I

71.1K viewsJul 28, 2020

YouTubeStudySpan

0:44

How to Use SUBTOTAL with SUM in Excel | Excel Tips for Beginners #sho…

536 views4 months ago

YouTubeLearn with Rinkesh

0:57

SUBTOTAL Formula in Excel Explained in 60 Seconds! 🔥 | Excel Tips #shorts #…

1.1K views5 months ago

YouTubeAdvancement

2:36

SUBTOTAL Formula in Excel | Excel Formulas & Functions | SUBTOTAL F…

412 views3 months ago

YouTubeSmart IT Class

6:25

Find in video from 0:00Introduction to Subtotal Function

The Subtotal Function For Excel Tables Total Row

109.1K viewsJun 25, 2020

YouTubeExcel Campus - Jon

1:49

Find in video from 00:39Removing Filters

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

8.5K viewsFeb 28, 2023

YouTubeMrExcel.com

7:08

Find in video from 0:00Introduction to Subtotals

How To... Use Subtotals for Data Analysis in Excel 2010

58K viewsAug 19, 2011

YouTubeEugene O'Loughlin

0:42

Add Subtotals in Excel Like a Pro in 2024

5.4K viewsOct 4, 2024

YouTubeBright Minds Hub

5:14

How to Use the SUBTOTAL Function in Excel Step-by-Step Guide | SUBTOTA…

31 viewsSep 19, 2024

YouTubeExcel with Dilshad

4:05

How to Use SUBTOTAL in Excel | Dynamic Summarization Explained Si…

104 views3 months ago

YouTubeDataDA

See more videos

Top suggestions for Filter Subtotal in Excel