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......because yellow cells match with criteria 1. MAXIFS returns the largest...because green cells match with criteria 2. D:20161116101756Z Aspose...