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......89 1 MINIFS(A1:A6,B1:B6,1) 85 93 2 MAXIFS(A1:A6,B1:B6,2) 96 96...96 2 85 1 91 2 88 1 MINIFS returns the smallest of yellow cells...