Returns the minimum value among cells specified by a given set of conditions or criteria.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
MINIFS(min_range, criteria_range1, criteria1, ...)The MINIFS function allows you to find the smallest value in a range based on one or more logical conditions. It is highly useful for filtering data sets to identify minimums within specific categories or date ranges.
=MINIFS(B2:B10, A2:A10, "Electronics")결과: 150
Returns the minimum value in B2:B10 where the corresponding cell in A2:A10 is 'Electronics'.
Yes, you can add additional criteria_range and criteria pairs as needed.