=SUM (COUNTIF (INDIRECT ({"B5:B12","D5:D14","F7:F11"}),">80")) 使用COUNTIF函數,輸入公式「=COUNTIF (B2:B19,”>80″)+COUNTIF (D2:D19,”>80″)」,分別 ...
確定! 回上一頁