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
-
38:57
The Why Files
1 day agoBackyard Time Machine: The Time Travel Mystery of Mike “Mad Man” Marcum
45.9K60 -
3:58:52
Due Dissidence
17 hours agoBronx Trump Rally SPECIAL REPORT, Chappelle SLAMS Israel, Greenwald OWNS Dershowitz
55K109 -
21:53
Breaking Points
19 hours ago5/26/24 AMA
24.1K10 -
2:58:31
SonnyFaz
11 hours agoSNEAKO X SONNY NEW YORK TAKEOVER!
44.8K37 -
2:13:04
vivafrei
19 hours agoEp. 212: Trump FBI Raid; Alex Jones' Lawyer Victory; Biden Ballot & MORE! Viva & Barnes
136K263 -
6:38:26
PudgeTV
13 hours agoBorderlands 2 From the Content Creator House | Fortnite w Frag | Happy Memorial Day Weekend
61.8K10 -
3:32:12
SNEAKO
15 hours agoNYC One Minute Podcast! (DAY 2)
140K111 -
1:43:15
WeAreChange
14 hours agoTrump Endorses FREE MARKET Money As Biden GLORIFIES George Floyd!
90.8K131 -
2:15:35
SilverFox
16 hours ago🔴LIVE - Elden Ring from the RUMBLE CREATOR HOUSE!!
65.5K2 -
3:12:08
FusedAegisTV
18 hours ago33 Days to Dawntrail🕒| JIMI HENDRIX PLAYS FFXIV Online Endwalker 6.0 MSQ
62K9