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 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(
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 Microsoft #Excel | SUM vs. SUBTOTAL vs. AGGREGATE =AGGREGATE(9,7,C6:C14) | Excel Basement
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 Mod…
4:24
Excel: Groups and Subtotals
617K viewsFeb 8, 2016
YouTubeLearnFree
7:04
Hiding Data in Excel
163K viewsJan 7, 2019
YouTubeTechnology for Teachers and Students
2:54
How to Unhide Rows in Excel
377K viewsMar 18, 2019
YouTubeExcel Tutorials by EasyClick Academy
2:01
How to Hide Rows in Excel
90K viewsMar 18, 2019
YouTubeExcel Tutorials by EasyClick Academy
6:32
Running Totals In Excel Tables - The Efficient Way
86.7K viewsJul 23, 2020
YouTubeExcel Campus - Jon
8:08
How To Use The Subtotal Feature And Subtotal Function In Excel
380.3K viewsJul 2, 2020
YouTubeExcel Campus - Jon
6:25
The Subtotal Function For Excel Tables Total Row
111.7K viewsJun 25, 2020
YouTubeExcel Campus - Jon
6:43
3 Methods to Unhide All Sheets in Excel (& how to hide)
324.8K viewsJan 17, 2019
YouTubeLeila Gharani
4:28
How to Sum Values If a Cell Contains a Specific Text | SKYXCEL
206.6K viewsNov 28, 2019
YouTubeSKYXCEL
2:17
How to Select Only the Visible Cells in Excel (SHORTCUT)
65.3K viewsOct 18, 2019
YouTubeTrumpExcel
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 Tutorial - Episode 1034
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.3K 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 using the SUM function
12.4K viewsAug 23, 2017
YouTubeMaths and Stats
7:44
HOW TO Unhide Columns in Excel (inc. unhide Column A and unhide Row 1)
119.3K viewsNov 27, 2019
YouTubeExcel at Work
10:54
Excel SUMIFS: Sum Alternate Columns based on Criteria and Header
463.5K viewsApr 21, 2017
YouTubeLeila Gharani
4:26
Delete Hidden or Visible Records after Applying Filter in Excel
69.1K viewsAug 24, 2021
YouTubeChester Tugwell
1:11
Excel Quick Tip: Find a Sum Without Using a Formula
61.5K viewsJan 23, 2018
YouTubeLearnFree
6:18
How to Exclude Values in COUNTIF | COUNTIFS NOT EQUAL to Multiple Text | Exclude Values from List
67.3K viewsJun 22, 2021
YouTubeChester Tugwell
5:06
Excel AGGREGATE Function: Ignore Error Values, Subtotals & Hidden Rows –
Nov 3, 2017
bluepecantraining.com
See more