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......smallest of yellow cells because yellow cells match with criteria...largest of green cells because green cells match with criteria...