[已解决]依据条件区域选项，自动统计数据

jf530qy

各路大神好

求助：
依据条件区域选项，能自动依据数据区进行统计的函数

感谢
[img]blob:http://www.excelpx.com/320afd9d-83c1-4105-a343-391d6352dd5b[/img]

最佳答案

月排行榜 / 总排行榜

baksy

2021-5-17 17:03

=SUMIFS(D$9:D$19,$B$9:$B$19,">="&$B6,$C$9:$C$19,"<="&IF($C6="",9^9,$C6))

跳转到最佳答案楼层

baksy

=SUMIFS(D$9:D$19,$B$9:$B$19,">="&$B6,$C$9:$C$19,"<="&IF($C6="",9^9,$C6))

cutecpu

=SUM(IF(LOOKUP($B$9:$B$19,$B$6:$B$8)=$B6,D$9:D$19))

※數組公式，請記得按Ctrl+Shift+Enter

祝順心，南無阿彌陀佛！