A. 对 B. 错
A. =sumif(k2:k20,人员甲) B. =SUMIF(Sheet1!K2:K20,”人员甲”,Sheet1!H2:H20) C. =SUMIF(sheet1!k2:k20,”人员甲”) D. =sumif(sheet1!k3:k7,,”人员甲”,SHEET1!h2:h20)
A. 求和 B. 求平均值 C. 条件求和 D. 计数