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
-
1:25:14
Sarah Westall
3 hours agoBlackmail, Power & Corruption: The Currency of the Empire - Epstein & more w/ Joachim Hagopian
20.4K5 -
16:33
Clownfish TV
8 hours agoLate Night TV Has NO FUTURE After Stephen Colbert's Cancellation!
4K8 -
45:56
The White House
3 hours agoPresident Trump Visits the Federal Reserve
31.6K19 -
36:14
Kimberly Guilfoyle
4 hours agoRussia Hoax Reality Check, Live! | Ep240
29.4K10 -
11:02
Preston Stewart
8 hours ago $0.61 earnedThailand–Cambodia Clash Erupts
10.5K3 -
LIVE
LFA TV
21 hours agoLFA TV ALL DAY STREAM - THURSDAY 7/24/25
946 watching -
1:07:35
vivafrei
5 hours agoWall Street Journal DOUBLING DOWN on Epstein! Lawyer in Canada DEBANKED! AND MORE!
110K34 -
4:42:20
Donut Operator
7 hours agoI'M BACK/ CRIME/ GAMEBOY CAMERA CHAD
106K5 -
9:51
Warren Smith - Secret Scholar Society
5 days agoThe Moment Tim Pool Discovered Why Andrew Wilson is so Unstoppable
43.1K26 -
28:23
Film Threat
6 hours agoLIVE FROM SAN DIEGO COMIC-CON! (Thursday) | Film Threat Live
25.9K2