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