=SUM(IF(((date>=$B$2)*(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()函数