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

42.9K viewsOct 22, 2021

Excel Filter Tutorial

15:54

Excel Tutorial for Beginners | How to Use Excel

YouTubeLeila Gharani

2.5M viewsFeb 4, 2021

10:30:00

Microsoft Excel Tutorial for Beginners | Excel Training | FREE Online Excel course

YouTubeProgrammingKnowledge

2.4M viewsJan 1, 2021

10:40:33

🔥 Complete Excel Course: Beginner To Expert | Advanced Excel Tutorial | Excel Training | Simplilearn

YouTubeSimplilearn

313.1K viewsJul 21, 2023

Top videos

5:49

Excel Filters with the SUBTOTAL Function

YouTubeChris Menard

10.6K viewsSep 14, 2023

1:26

Using Excel's Subtotal Function with Filters in Excel

YouTubeChris Menard

170.5K viewsSep 13, 2013

2:34

Calculate Total in Filtered Data in Excel | SUBTOTAL Function Tutorial

YouTubeExcel Training

22.3K viewsJul 2, 2024

Excel Advanced Filter

7:18

How to Use the Advanced Filter in Microsoft Excel

YouTubeSimon Sez IT

52.6K viewsMay 26, 2022

1:22

How to use Advanced Filter in Excel | Excel Tricks

YouTubeMicrosoft Office Tutorials

108.2K viewsSep 30, 2023

0:43

Master the Advanced Filter Function in Excel: Step-by-Step Guide

YouTubeOffice Shortcut

14.5K views10 months ago

5:49

Excel Filters with the SUBTOTAL Function

10.6K 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.5K viewsSep 13, 2013

YouTubeChris Menard

2:34

Find in video from 00:31Applying Data Filter

Calculate Total in Filtered Data in Excel | SUBTOTAL Function Tutorial

22.3K viewsJul 2, 2024

YouTubeExcel Training

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

YouTubeMike's Office

0:40

Use SUBTOTAL with Filter in Excel! #shorts #excel #exceltips

382 views2 months ago

YouTubeExcel Wiser

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)

371.9K viewsOct 1, 2019

YouTubeTrumpExcel

25:15

Advanced Excel: Custom Sorting, Filtering, Grouping & Subtotal Exp…

122 views2 months ago

YouTubeIT TECH

17:15

Find in video from 12:00Adding Filtering to Subtotals

Using Sumproduct Function In Excel To Subtotal Filtered Data

23.1K viewsApr 10, 2018

YouTubeGlenEClarkeTraining

9:12

Find in video from 01:14Understanding Filtering in Excel

Summarize filtered values in Excel with SUBTOTAL & AGGREGATE F…

10.8K viewsAug 25, 2015

YouTubeChandoo

0:38

How to sum filtered cells using subtotal formula #excel #spreadsh…

1.6K views2 months ago

YouTubeExcelFuel

2:58

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

1 views2 months ago

YouTubeEasy Click Learning

0:55

Find in video from 0:00Introduction to Subtotal Formula

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

20.7K viewsSep 2, 2021

YouTubeLearnYouAndMe

8:08

Find in video from 0:00Introduction to Subtotal Function

How To Use The Subtotal Feature And Subtotal Function In Excel

365.5K viewsJul 2, 2020

YouTubeExcel Campus - Jon

7:07

Find in video from 0:00Introduction to Filtering Data

3 Ways to Filter Data in Excel

84.8K viewsFeb 8, 2024

YouTubeTeacher's Tech

0:46

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

54.4K views11 months ago

YouTubeExcel Campus - Jon

11:01

SUBTOTAL: The Excel Function You Didn’t Know You Needed!

16K views6 months ago

YouTubeKenji Explains

3:36

Find in video from 00:30Filtering Data with Count A Function

Count Filtered Rows With this Easy Formula

32.9K viewsMar 5, 2024

YouTubeTrumpExcel

5:05

Find in video from 0:00Introduction to Filter Function

How to use the FILTER Function in Excel (multiple use cases)

9.5K viewsMar 27, 2024

YouTubeExcel Dictionary

6:16

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

1.5K views4 months ago

YouTubeStudySpan

6:34

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

SUBTOTAL Function | The Best Excel Formula | Practical Exampl…

988 viewsMar 1, 2024

YouTubeJopa Excel

3:07

Subtotal formula in Excel | Ms Office |

414 views10 months ago

YouTubeAao Sikhain

17:47

15- Microsoft Excel Advanced Tutorials |Subtotal | IT Plus

207 views11 months ago

YouTubeIT Plus

0:40

Find in video from 00:27Removing Subtotals

Excel Pivot Table: How to Remove Subtotals

3.5K viewsMay 20, 2024

YouTubeCogwheel Learning

5:34

Find in video from 00:02Introduction to Subtotal Function

Automatic Subtotals in Excel

12.1K viewsMar 18, 2016

YouTubeIQ Accounting Solutions

7:31

Find in video from 05:53Using Subtotals in Excel Tables

How to Use the Excel SUBTOTAL Function | SUBTOTAL vs SUM | 9 …

4.5K viewsFeb 28, 2024

YouTubeChester Tugwell

0:57

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

1.1K views4 months ago

YouTubeAdvancement

0:24

SUBTOTAL Function in Excel | Advanced Data Analysis

63 views6 months ago

YouTubeComputer Skills

2:36

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

172 views2 months ago

YouTubeSmart IT Class

1:19

How to Sum Only Visible Cells in Excel After Applying a Filter | SUB…

17 views6 months ago

YouTubeBest_Excel

See more videos

Top suggestions for Filter Subtotal in Excel