=SUM(IF(((date>=$B$2)*(date

来源：学生作业帮助网编辑：六六作业网时间：2024/11/28 16:13:38

=SUM(IF(((date>=$B$2)*(date=SUM(IF(((date>=$B$2)*(date=SUM(IF(((date>=$B$2)*(date这是数组函数,符合多个条件（date>

=SUM(IF(((date>=$B$2)*(date
=SUM(IF(((date>=$B$2)*(date<=$D$2))*(name=$A5)*(type=F$4),number))

=SUM(IF(((date>=$B$2)*(date
这是数组函数,符合多个条件（date>=$B$2,date<=$D$2,name=$A5,type=F$4),求和值,也可用sumproduct()函数