# How to Use MINIFS in Google Sheets in 2020?

MINIFSReturns the minimum value in a range of cells, filtered by a set of criteria.

Sample Usage

MINIFS(A1:A3, B1:B3, 1, C1:C3, “A”)

MINIFS(D4:E5, F4:G5, “>5”, F6:G7, “<10”) Syntax MINIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2, …]) range - The range of cells from which the minimum will be determined. criteria_range1 - The range of cells over which to evaluate criterion1. criterion1 - The pattern or test to apply to criteria_range1. criteria_range2, criterion2, ... - Optional: Additional ranges and their associated criteria. Note that filtering will result in the intersection of these. Notes MINIFS will return 0 if none of the criterion are satisfied. range and all of the criterion ranges must be the same size. If they aren't, MINIFS will return a #VALUE error. See Also MAXIFS: Returns the maximum value in a range of cells, filtered by a set of criteria. SUMIFS: Returns the sum of a range depending on multiple criteria. MIN: Returns the minimum value in a numeric dataset. Example A B C 1 ID Score Section 2 123 30 B 3 102 28 A 4 157 29 A 5 189 19 B 6 7 Solution Formula 8 102 = MINIFS(A2:A5, B2:B5, ">25″, C2:C5, “A”)

9
123
= MINIFS(A2:A5, B2:B5, “>25”, C2:C5, “B”)

10
123
= MINIFS(A2:A5, B2:B5, “<35", C2:C5, “B”) 11 0 = MINIFS(A2:A5, B2:B5, ">35″, C2:C5, “B”)

Categories Uncategorized Tags