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

来源：学生作业帮助网编辑：六六作业网时间：2024/11/26 12:47:58

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

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