دالة Google Sheets

MINIFS

Returns the minimum value among cells specified by a given set of conditions or criteria.

إنشاء صيغة بالذكاء الاصطناعي نفس الدالة في Excel

تعمل هذه الدالة في 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.

المعاملات

min_rangeمطلوبThe actual range of cells in which to determine the minimum 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.

أمثلة

=MINIFS(B2:B10, A2:A10, "Electronics")

النتيجة: 150

Returns the minimum value in B2:B10 where the corresponding cell in A2:A10 is 'Electronics'.

الأسئلة الشائعة

Can I use multiple criteria with MINIFS?

Yes, you can add additional criteria_range and criteria pairs as needed.

دوال ذات صلة

MIN MAXIFS AVERAGEIFS SUMIFS