Excel - How to use the Subtotal Function with Filters
4:38
YouTubeChris Menard
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
Shorts
Quickly Add or Remove Filters in Excel | Time-Saving Tricks & Shortcuts
0:22
2.7K views
Quickly Add or Remove Filters in Excel | Time-Saving Tricks & Shortcuts
Bright Minds Hub
Did you filter data in Excel? Here's how to add it up correctly.
1:15
2.3K views
Did you filter data in Excel? Here's how to add it up correctly.
Tutorial Excel
Microsoft Excel Excel Tips and Tricks
Top 20 Microsoft Excel Tips & Tricks
25:38
Top 20 Microsoft Excel Tips & Tricks
YouTubeKevin Stratvert
871.2K viewsOct 23, 2020
50 Ultimate Excel Tips and Tricks for 2020
50:17
50 Ultimate Excel Tips and Tricks for 2020
YouTubeSele Training
1.9M viewsMar 17, 2020
30 Essential Excel Tips and Tricks for 2024 - Excel Productivity Tutorial
2:07:11
30 Essential Excel Tips and Tricks for 2024 - Excel Productivity Tutorial
YouTubeSimon Sez IT
100.1K viewsJan 9, 2024
Top videos
Using Excel's Subtotal Function with Filters in Excel
1:26
Using Excel's Subtotal Function with Filters in Excel
YouTubeChris Menard
170.9K viewsSep 13, 2013
Excel Filters with the SUBTOTAL Function
5:49
Excel Filters with the SUBTOTAL Function
YouTubeChris Menard
16.8K viewsSep 14, 2023
FILTER Function to Create Sub Table from Master Table. Data Validation Too! Excel Magic Trick 1842
3:33
FILTER Function to Create Sub Table from Master Table. Data Validation Too! Excel Magic Trick 1842
YouTubeexcelisfun
17.2K viewsOct 25, 2023
Microsoft Excel Excel Formulas
Top 10 Most Important Excel Formulas - Made Easy!
27:19
Top 10 Most Important Excel Formulas - Made Easy!
YouTubeThe Organic Chemistry Tutor
8.5M viewsJun 8, 2018
How to create formulas in Microsoft Excel
1:38
How to create formulas in Microsoft Excel
YouTubeMicrosoft 365
428.7K viewsFeb 17, 2021
Top Excel Formulas and Functions
2:31:06
Top Excel Formulas and Functions
YouTubeSimon Sez IT
147.7K viewsJan 17, 2024
Using Excel's Subtotal Function with Filters in Excel
1:26
Using Excel's Subtotal Function with Filters in Excel
170.9K viewsSep 13, 2013
YouTubeChris Menard
Excel Filters with the SUBTOTAL Function
5:49
Excel Filters with the SUBTOTAL Function
16.8K viewsSep 14, 2023
YouTubeChris Menard
FILTER Function to Create Sub Table from Master Table. Data Validation Too! Excel Magic Trick 1842
3:33
FILTER Function to Create Sub Table from Master Table. Data Vali…
17.2K viewsOct 25, 2023
YouTubeexcelisfun
Filtering in Excel: Basics and Beyond
8:05
Filtering in Excel: Basics and Beyond
51K viewsDec 6, 2021
YouTubeTechnology for Teachers and Students
How to Create Filter in Excel
2:51
How to Create Filter in Excel
1.4M viewsJul 31, 2019
YouTubeExcel Tutorials by EasyClick Academy
Excel Sorting and Filtering Data
13:29
Excel Sorting and Filtering Data
1M viewsJun 7, 2018
YouTubeThe Organic Chemistry Tutor
Filtering Data in Excel Like a Pro! 🔍 | Text, Numbers, Dates + Advanced Filter Tricks!
11:54
Filtering Data in Excel Like a Pro! 🔍 | Text, Numbers, Dates + Advanced …
13.3K views6 months ago
YouTubeTutorialsPoint
4:38
How to use Filter Function in Microsoft Excel | Filter Formula in …
52.4K views9 months ago
YouTubeStudySpan
1:06
How to filter data in a range or table in Microsoft Excel
455.2K viewsFeb 17, 2021
YouTubeMicrosoft 365
5:57
Easily Format and Filter data with Excel Tables and Slicers
17.8K viewsJul 20, 2021
YouTubeMike's Office
7:18
How to Use the Advanced Filter in Microsoft Excel
56.4K viewsMay 26, 2022
YouTubeSimon Sez IT
22:17
Ultimate Guide to the FILTER Function in Excel 365
9.5K viewsSep 30, 2024
YouTubeSimon Sez IT
12:40
Excel FILTER Function Explained (7 Examples) | Filter and Extract Dat…
127.1K viewsFeb 13, 2020
YouTubeTrumpExcel
8:27
How to Use the FILTER Function in Excel - Excel FILTER Tutorial
79.8K viewsMar 16, 2021
YouTubeSimon Sez IT
3:30
How to use Filter function in Excel and Filter data based on 1 or 2 or …
75.1K viewsApr 2, 2020
YouTubeExcel Rush
1:22
How to use Advanced Filter in Excel | Excel Tricks
138.9K viewsSep 30, 2023
YouTubeMicrosoft Office Tutorials
10:17
Excel FILTER Function incl. Trick to Rearrange Column Order
185.1K viewsOct 14, 2021
YouTubeMyOnlineTrainingHub
12:12
Excel’s Ultimate FILTER Hack - Multiple Columns, Multiple Values 😲
32.4K views7 months ago
YouTubeExcel Off The Grid
2:32
Get the Sum of Filtered Data in Excel (Using SUBTOTAL Formula)
377.3K viewsOct 1, 2019
YouTubeTrumpExcel
7:23
Using the FILTER Function in Microsoft Excel 2021/365: OR Ope…
14.4K viewsNov 7, 2022
YouTubeSimon Sez IT
2:58
Sum Filtered Data in Excel with SUBTOTAL (The Right Way!)
317 views5 months ago
YouTubeEasy Click Learning
0:46
Sum with Filter: Accurate totals even with filtered data in Excel?
87.5K viewsOct 21, 2024
YouTubeExcel Campus - Jon
4:57
Using the Excel SUBTOTAL Function
286.2K viewsJul 3, 2023
YouTubeTechnology for Teachers and Students
2:34
Calculate Total in Filtered Data in Excel | SUBTOTAL Function Tutorial
23.3K viewsJul 2, 2024
YouTubeExcel Training
6:02
Create Custom Filters Using Excel Advanced Filter
188.6K viewsJun 6, 2012
YouTubeTrainSignal is now Pluralsight
1:49
Excel - Find Out How To Add Subtotals To Your Filtered Data In …
8.7K viewsFeb 28, 2023
YouTubeMrExcel.com
5:28
How to Use Advanced Filters in Excel
1.1K views3 weeks ago
YouTubeSimon Sez IT
9:03
Advanced Filters in Excel | How to Filter and Copy Data with Multiple …
25K views11 months ago
YouTubeAnser's Excel Academy
0:46
How to Replace Text in Excel Using the SUBSTITUTE Function | Excel …
977 viewsAug 18, 2024
YouTubeOnly solutions
See more videos
Static thumbnail place holder