Sheet1 89 1 MINIFS(A1:A6,B1:B6,1) ERROR:#NAME? 93 2 MAXIFS(A1:A6,B1:B6,2) ERROR:#NAME? 96 2 85 1 91 2 88 1 MINIFS returns the smallest of yellow cells because yellow cells match with Criteria 1. MA......because yellow cells match with criteria 1. MAXIFS returns the largest...because green cells match with criteria 2. 2016-11-16T10:17:46Z 15...