Returns the maximum value among cells specified by a given set of conditions or criteria.
الصيغة
MAXIFS(max_range, criteria_range1, criteria1, ...)المعاملات
max_rangeمطلوب
The actual range of cells in which to determine the maximum value.
criteria_range1مطلوب
The range of cells to evaluate by the associated criteria.
criteria1مطلوب
The condition that defines which cells in criteria_range1 will be considered.
The MAXIFS function allows you to find the largest value in a range based on one or more criteria. You can apply multiple conditions across different ranges, and only cells that meet all specified criteria are evaluated for the maximum value.
=MAXIFS(C2:C10, A2:A10, "Sales", B2:B10, ">100")→500Returns the maximum value from C2:C10 where column A is 'Sales' and column B is greater than 100.
Select the target cell
Click on the cell where you want to display the maximum value result.
Enter the formula
Type =MAXIFS followed by the range to evaluate and your specific criteria, then press Enter.
Yes, you can add up to 127 range/criteria pairs to the function.