Premium Only Content

Excel MAX or MIN with CONDITIONS (MAXIFS & AGGREGATE Method)
22 August 2019 Excel Advanced Formulas & Features
Is there an Excel Max IF or MIN IF function? If you have Excel for Office 365 or Excel 2019, you can use MAXIFS and MINIFS functions which allow us to find the maximum or minimum value in a data set based on multiple conditions. For example if you wanted to find the MIN value but exclude zero values, you can use the MINIFS function to do that.
If you have an older version of Excel, you can use an alternate method. The common solution is {=Max(If (array) )} but you need to press Control Shift Enter (CSE).
Another method to get the maximum or minimum value based on criteria is to use the AGGREGATE function. The advantage of AGGREGATE is you don't need to press control shift enter. Just enter. You need a little trick to get to work. We cover that in this video.
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-maxifs-minifs-with-conditions
More IFS functions - like SUMIFS: https://rumble.com/v2skgke
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani
-
LIVE
LFA TV
14 hours agoLFA TV ALL DAY STREAM - WEDNESDAY 7/30/25
4,281 watching -
LIVE
JuicyJohns
2 hours ago $1.39 earned🟢#1 REBIRTH PLAYER 10.2+ KD🟢$500 GIVEAWAY
120 watching -
53:02
The Official Corbett Report Rumble Channel
14 hours agoHow to Leave the Cage - #SolutionsWatch
4.83K2 -
42:47
Outspoken with Dr. Naomi Wolf
16 hours ago"Jonathan Pollard: Are Allies of Israel being Targeted?"
12.5K4 -
1:29:49
Game On!
18 hours ago $1.89 earned10,000 Followers Celebration Stream! Let's Talk Sports!
43K2 -
15:38
SKAP ATTACK
20 hours ago $3.03 earnedA Legacy Tainted: Unpacking the LeBron Steroid Rumors
42.5K13 -
2:04:52
The Confessionals
22 hours agoThe Great Spiritual Hijack — And Why It’s Ending
36.7K7 -
1:49:30
Nick Freitas
16 hours agoHere's Why The Housing Market Is Permanently Broken
30.7K4 -
17:03
Nicholas Bowling
20 hours ago $1.57 earned"Celebrity" Tells Street Preacher His Dad's in the ILLUMINATI
24K4 -
2:01:09
BEK TV
23 hours agoTrent Loos in the Morning - 7/30/2025
22K