SUM(IF(A1：A100SUM(IF(H级!B6:B53

来源：学生作业帮助网编辑：作业帮时间：2024/04/28 14:54:48

SUM(IF(A1：A100SUM(IF(H级!B6:B53
SUM(IF(A1：A100
SUM(IF(H级!B6:B53

SUM(IF(A1：A100SUM(IF(H级!B6:B53
=SUM(IF(A1:A1005?,1,0)))
数组 ?修改为单元格或具体的数据
或 =SUMPRODUCT((A1:A100>=C1)*(A1:A5

用sumifs

fygf