89 1 MINIFS(A1:A6,B1:B6,1) 85 93 2 MAXIFS(A1:A6,B1:B6,2) 96 96 2 85 1 91 2 88 1 MINIFS returns the smallest of yellow Cells because yellow Cells match with criteria 1. MAXIFS returns the largest of......smallest of yellow cells because yellow cells match with criteria...largest of green cells because green cells match with criteria...