1. What is MaxIFs & MinIFs Excel function
2. How to use MaxIFs & MinIFs Excel function
3. What are the arguments in MaxIFs & MinIFs Excel function
4. What are the limitation of MaxIFs & MinIFs Excel function
5. Are these functions (MaxIFs & MinIFs) available in your Excel?
6. What are the eligibility to get these Excel functions (MaxIFs & MinIFs)?

Only the following user can use this new excel functions. Since, it is a new Excel function, now it is only available for the following users:

பின்வரும் பயனரால் மட்டுமே இந்த புதிய எக்செல் செயல்பாடுகளைப் பயன்படுத்த முடியும். இது ஒரு புதிய எக்செல் செயல்பாடு என்பதால், இப்போது இது பின்வரும் பயனர்களுக்கு மட்டுமே கிடைக்கிறது:

1. Office 365
2. Office 2019
3. Office on Web

As of now, the users with older versions could not use this wonderful Excel function. But still, you can use this with the help of Office on Web. Okay, lets understand the arguments of these functions.

=MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

1. max_range or min_range – required argument – The range of cells in which the maximum or minimum value will be determined. We use this to find our maximum and minimum sales values.
2. criteria_range1 – required argument – Is the set of cells to evaluate the criteria. We use this range to validate our product such as iPhone, Samsung ..
3. criteria1 – required argument – Is the criteria in the form of a number, expression, or text that defines which cells will be evaluated as maximum or minimum criteria. We use this to set our criteria to the 1st set of validation.
4. criteria_range2, criteria2, … – optional arguments – Additional ranges and their associated criteria. You can enter up to 126 range/criteria pairs. We use these criteria_range2 and criteria2 to determine the rest of the validations. 

Note: The cells under the criteria_range1 and max_range should be same. Otherwise, you will get the #VALUE! error.