Returns the maximum value among cells specified by a given set of conditions or criteria.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
MAXIFS(max_range, criteria_range1, criteria1, ...)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")결과: 500
Returns the maximum value from C2:C10 where column A is 'Sales' and column B is greater than 100.
Yes, you can add up to 127 range/criteria pairs to the function.