SUM(IF(A1:A100SUM(IF(H级!B6:B53
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/04 17:23:48
![SUM(IF(A1:A100SUM(IF(H级!B6:B53](/uploads/image/z/5528924-44-4.jpg?t=SUM%28IF%28A1%EF%BC%9AA100SUM%28IF%28H%E7%BA%A7%21B6%3AB53)
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