excel在sheet1表里,有5个区域数据如何找出,有最小值区域数据在shee2里...答:如果只是显示这个最小值,在Sheet2的S1输入公式:=IF(COUNTIF(Sheet1!S1:U9,MIN(Sheet1!A1:C9,Sheet1!G1:O9,Sheet1!S1:U9,Sheet1!V1:X9)),MIN(Sheet1!A1:C9,Sheet1!G1:O9,Sheet1!S1:U9,Sheet1!V1:X9),"")如果是显示这个区域,在Sheet2的S1输入公式如下 =IF(COUNTIF(Sheet1!$...