An Excel array formula to count cells that meet two conditions ... Maximum: =MAX(IF(($A$2:$A$9=$F$1) * ($B$2:$B$9=$F$2), $C$2:$C$9,"")).
確定! 回上一頁