Excel MAX or MIN with CONDITIONS (MAXIFS & AGGREGATE Method)
Автор: Leila Gharani
Загружено: 2019-08-22
Просмотров: 230813
Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou...
Uncover the power of MINIFS and MAXIFS Excel functions. These tools are essential for extracting minimum or maximum values based on specific criteria. Suitable for Excel 2019 and Office 365 users, with alternatives for those on older versions.
⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/max-min-file
▪️ MAXIFS and MINIFS Functions:
Purpose: Easily calculate maximum and minimum values based on one or more criteria.
Example: Find the highest and lowest revenue for a specific year and division.
Procedure: Select your data range and criteria in the MAXIFS/MINIFS function.
▪️ Using AGGREGATE for Older Excel Versions:
Alternative: AGGREGATE function is a versatile substitute for those without access to the latest Excel versions.
Approach: Combine logical tests within the AGGREGATE function, using LARGE (for MAXIFS) and SMALL (for MINIFS) arguments.
Key Benefit: No need for Ctrl+Shift+Enter to execute array formulas, thanks to AGGREGATE's inherent handling of arrays.
▪️ Efficient Data Analysis:
Flexibility: Whether using the latest Excel functions or older versions, you can efficiently analyze data to extract meaningful insights.
Customization: Adapt formulas to fit various datasets and criteria, ensuring versatile application across different scenarios.
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.
More IFS functions - like SUMIFS: • How to Use SUMIFS, COUNTIFS and AVERAGEIFS...
★ My Online Excel Courses ► https://www.xelplus.com/courses/
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: https://www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
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!
#excel
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
![[ НОВЫЙ 2025 ] Уральские Пельмени -Смейтесь без остановки вместе с комедийной группой №1 в России!](https://ricktube.ru/thumbnail/CKS2HBi2g_E/mqdefault.jpg)
