Get the Total Sales Excluding Hidden Rows & based on Multiple Criteria in #Excel 365 =SUM(FILTER(Data[Sales], (Data[Sales person]=B27)* (Data[Region]=D27)* (ISNUMBER(SEARCH(C27,Data[Product]))* (SUBTOTAL(103, OFFSET(B6, ROW(Data[Sales person])-MIN( ROW(Data[Sales person])),0))=1)))) Explanation: (Data[Sales person]=B27)* (Data[Region]=D27)* (ISNUMBER(SEARCH(C27,Data[Product])) Checking the Criteria Based on Sales Person, Region and Wildcard Search on Product Column. SUBTOTAL(103, OFFSET(B6, ROW(
0:58
Get the Total Sales Excluding Hidden Rows & based on Multiple …
1.2K viewsFeb 25, 2024
FacebookExcel Basement
Sum visible rows in a filtered list
Sum visible rows in a filtered list
Jan 3, 2023
exceljet.net
How to Hide Rows in Excel
4:54
How to Hide Rows in Excel
285.9K viewsMar 10, 2025
wikiHow
How to Exclude the Hidden Rows Data & Errors to Get the Total? in Microsoft #Excel | SUM vs. SUBTOTAL vs. AGGREGATE =AGGREGATE(9,7,C6:C14) | Excel Basement
0:31
How to Exclude the Hidden Rows Data & Errors to Get the Total? in …
45.7K viewsMay 11, 2023
FacebookExcel Basement
Sum if not blank
Sum if not blank
Apr 28, 2025
exceljet.net
SUMPRODUCT only visible cells
SUMPRODUCT only visible cells
Oct 24, 2023
auditexcel.co.za
SUMPRODUCT visible cells only
1:40
SUMPRODUCT visible cells only
7.8K viewsNov 22, 2019
YouTubeAuditExcel Advanced Excel and Financial Mode…
4:24
Excel: Groups and Subtotals
617.5K viewsFeb 8, 2016
YouTubeLearnFree
7:04
Hiding Data in Excel
163.1K viewsJan 7, 2019
YouTubeTechnology for Teachers and Students
2:54
How to Unhide Rows in Excel
377.3K viewsMar 18, 2019
YouTubeExcel Tutorials by EasyClick Academy
2:01
How to Hide Rows in Excel
90.2K viewsMar 18, 2019
YouTubeExcel Tutorials by EasyClick Academy
1:29
How to Remove Zero Value Rows from a Pivot Table
93.5K viewsSep 21, 2020
YouTubeUp4Excel
6:32
Running Totals In Excel Tables - The Efficient Way
86.6K viewsJul 23, 2020
YouTubeExcel Campus - Jon
8:08
How To Use The Subtotal Feature And Subtotal Function In Excel
378.9K viewsJul 2, 2020
YouTubeExcel Campus - Jon
8:09
Excel SUMPRODUCT Function - A Guide to a Powerful Excel Function
104.1K viewsJun 23, 2016
YouTubeComputergaga
6:25
The Subtotal Function For Excel Tables Total Row
111.4K viewsJun 25, 2020
YouTubeExcel Campus - Jon
6:43
3 Methods to Unhide All Sheets in Excel (& how to hide)
325.2K viewsJan 17, 2019
YouTubeLeila Gharani
4:28
How to Sum Values If a Cell Contains a Specific Text | SKYXCEL
205.2K viewsNov 28, 2019
YouTubeSKYXCEL
1:02
How to Sum a Column or Row of Excel Cells
1.1M viewsJan 28, 2016
YouTubeeHowTech
2:14
Excel - Counting Only Visible Rows in Excel | SUBTOTAL Function Tut…
95.5K viewsJun 11, 2009
YouTubeMrExcel.com
2:29
How to calculate excluding hidden rows in Excel
65.4K viewsDec 1, 2017
YouTubeBarb Henderson
6:58
Excel Trick: Sum a Specific Number of Cells
111.4K viewsApr 24, 2017
YouTubeA Simple Model
5:56
How to Copy Filtered Data Without Hidden Rows In Microsoft Excel
264.4K viewsJul 13, 2018
YouTubeNurture Tech
8:37
How to Use SUMIFS with Partial Match and Wildcards in Excel
115.5K viewsNov 29, 2018
YouTubeLeila Gharani
5:43
Excel Basics: How to sum the values in rows and columns usin…
12.4K viewsAug 23, 2017
YouTubeMaths and Stats
7:44
HOW TO Unhide Columns in Excel (inc. unhide Column A and unhide …
119.3K viewsNov 27, 2019
YouTubeExcel at Work
10:54
Excel SUMIFS: Sum Alternate Columns based on Criteria and He…
463.5K viewsApr 21, 2017
YouTubeLeila Gharani
1:52
Excel filter not working after certain row
112.6K viewsJan 20, 2021
YouTubeAuditExcel Advanced Excel and Financial Mode…
4:26
Delete Hidden or Visible Records after Applying Filter in Excel
69.7K viewsAug 24, 2021
YouTubeChester Tugwell
1:11
Excel Quick Tip: Find a Sum Without Using a Formula
61.6K viewsJan 23, 2018
YouTubeLearnFree
See more videos
Static thumbnail place holder