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 ...

46K viewsOct 22, 2021

Excel Filter Tutorial

6:23

How to APPLY FILTER in Excel STEP BY STEP

YouTubeExcel at Work

14.9K viewsMar 6, 2025

22:17

Ultimate Guide to the FILTER Function in Excel 365

YouTubeSimon Sez IT

11K viewsSep 30, 2024

0:20

How to Use FILTER Function in Excel (Fast Data Filtering) #exceltips #excel

YouTubeExcel Simplified

1.7K views3 weeks ago

Top videos

5:49

Excel Filters with the SUBTOTAL Function

YouTubeChris Menard

18.8K viewsSep 14, 2023

2:34

Calculate Total in Filtered Data in Excel | SUBTOTAL Function Tutorial

YouTubeOffice Productivity Hub

23.7K viewsJul 2, 2024

8:34

Excel Lesson: Subtotals, Sort, and Filter

YouTubeMike's Office

13K viewsJan 25, 2019

Excel Advanced Filter

5:28

How to Use Advanced Filters in Excel

YouTubeSimon Sez IT

1.5K views3 months ago

5:07

Excel - Advanced Filters

YouTubeChris Menard

32.3K viewsAug 31, 2023

0:55

How to use Advanced Filtering in Excel (step by step guide)

YouTubeTheDataLearner

146 viewsFeb 18, 2025

5:49

Excel Filters with the SUBTOTAL Function

18.8K viewsSep 14, 2023

YouTubeChris Menard

2:34

Find in video from 00:31Applying Data Filter

Calculate Total in Filtered Data in Excel | SUBTOTAL Function Tutorial

23.7K viewsJul 2, 2024

YouTubeOffice Productivity Hub

8:34

Excel Lesson: Subtotals, Sort, and Filter

13K viewsJan 25, 2019

YouTubeMike's Office

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

1:49

Find in video from 00:39Removing Filters

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

8.8K viewsFeb 28, 2023

YouTubeMrExcel.com

Frequency, Proportion, Mean, Median, SD -Filter + SUBTOTAL in Excel

4:30

Find in video from 00:08Activating Filter

Frequency, Proportion, Mean, Median, SD -Filter + SUBTOTAL in …

4K viewsSep 10, 2022

YouTubeJoshua Emmanuel

2:58

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

363 views7 months ago

YouTubeEasy Click Learning

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)

380.7K viewsOct 1, 2019

YouTubeTrumpExcel

8:08

How To Use The Subtotal Feature And Subtotal Function In Excel

377K viewsJul 2, 2020

YouTubeExcel Campus - Jon

2:59

Find in video from 00:13Setting Up the Filter

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

40.9K viewsAug 31, 2022

YouTubeMrExcel.com

1:26

Using Excel's Subtotal Function with Filters in Excel

171.2K viewsSep 13, 2013

YouTubeChris Menard

7:00

SUBTOTAL in Excel | Full Beginner to Pro Guide

420 views3 months ago

YouTubeS2 Computer Education

0:37

Calculation in Filtered Data in Excel

341 viewsAug 12, 2024

YouTubeOffice Productivity Hub

6:16

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

23.5K views10 months ago

YouTubeStudySpan

0:28

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

4.7K views5 months ago

YouTubeEasy Click Learning

6:34

Find in video from 00:38Counting Total Orders with Subtotal Function

SUBTOTAL Function | The Best Excel Formula | Practical Exampl…

1.2K viewsMar 1, 2024

YouTubeJopa Excel

4:57

Using the Excel SUBTOTAL Function

301.2K viewsJul 3, 2023

YouTubeTechnology for Teachers and Students

2:42

Subtotal Formula in excel | ms excel subtotal function | #excel #exceltu…

1.6K views2 months ago

YouTubeUpciss Prime

5:45

How to Create Subtotal in Microsoft Excel Part-II

285.9K viewsJul 29, 2020

YouTubeStudySpan

4:38

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

66.2K views11 months ago

YouTubeStudySpan

17:15

Find in video from 12:00Adding Filtering to Subtotals

Using Sumproduct Function In Excel To Subtotal Filtered Data

23.7K viewsApr 10, 2018

YouTubeGlenEClarkeTraining

10:26

Sorting and Filtering Data in Excel | Vertically and Horizontally | Numb…

4.1K viewsMay 8, 2024

YouTubeJopa Excel

6:14

How to Count Data After Filter in Excel – 3 Quick & Easy Ways

13.6K viewsNov 30, 2023

YouTubeMyExcelOnline.com

1:10

SUBTOTAL Formula in Microsoft Excel Part-II #shorts #ytshorts #st…

6.8K views10 months ago

YouTubeStudySpan

4:20

Find in video from 03:37Manual Filtering and Subtotal Function

How to add dynamic totals to a filtered list in Microsoft Excel

9.1K viewsJul 4, 2023

YouTubeITsEasyTraining1st

0:18

Sum VISIBLE rows ONLY in Excel - SUBTOTAL Formula

6K viewsJun 27, 2024

YouTubeHow to Learn Excel

6:07

How to Summarise Filtered Data in Excel (Step-by-Step Tutorial)

1.8K viewsJun 4, 2024

YouTubeITsEasyTraining1st

1:10

How to insert automatic subtotals in Excel

146.4K viewsNov 23, 2012

YouTubeExcel, Word and PowerPoint Tutorials from Ho…

0:55

Find in video from 00:20Filtering Year 2020

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

20.8K viewsSep 2, 2021

YouTubeLearnYouAndMe

0:44

How to sum in FILTER Data using SUBTOTAL 💡 #excel #excel c excel…

5 views3 months ago

YouTubeExcel Xpress

See more videos

Top suggestions for Filter Subtotal in Excel