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......1) 85 93 2 MAXIFS(A1:A6,B1:B6,2) 96 96 2 85 1 91 2 88 1 MINIFS...green cells match with criteria 2. D:20161116101756Z Aspose.Cells...