Excel MAX or MIN with CONDITIONS | MAXIFS and MINIFS Functions in Excel

Video Description

The Excel #MAXIFS and #MINIFS functions return the largest or smallest value that meets one or more criteria in a range of values. Both functions are introduced in Excel 2019, but how you can get the maximum or minimum value based on criteria in the older version of excel? to do that you can use array formulas with the MAX or MIN function. In this video, I have explained in detail to get the condition based maximum or minimum value from a range of values. Learn how to use the MINIFS & MAXIFS functions to find the Minimum and Maximum values in a column based on one or more conditions or criteria in excel 2016 or older version or in Excel 365 or Excel 2021. ------------------------------------------------------------------------------------------------------------- Subscribe to YouTube & Follow on Facebook Page👇 https://www.YouTube.com/exceluniverse https://www.facebook.com/exceluniverse.in Excel MAX and MIN Functions👇 https://youtu.be/6e43Rtl2rTY How to use Nested IF in Excel👇 https://youtu.be/fqLthtZ0qIw All About Average-Basic👇 https://youtu.be/BRRTPMhgiqc Extract Unique List in Excel 2016👇 https://youtu.be/2FHavILdzuU Index Function :- Array & Reference👇 https://youtu.be/NqAw5BstRGg All About MATCH Function👇 https://youtu.be/eJNIGfZ6Hq0 VLOOKUP with MATCH Function👇 https://youtu.be/K1ZMmcRFuto 3D LOOKUP 👇 https://youtu.be/9N7GWWXfFLk Download File from Link Below👇 https://mega.nz/file/IjoiwQIL#C9Yo391oW-l86bY7e6Zc74p9FVW0ZmM9jjU_kv_aF58