这个公式能精简吗？

用户坪坝

1. =COUNTIFS([data_all.xlsm]Sheet1!$B:$B,">="&$B3,[data_all.xlsm]Sheet1!$B:$B,"="&$B3,[data_all.xlsm]Sheet1!$B:$B,"

复制代码

尹先森

最好把附件传上来。

吃的

不可以，只是3个条件，不算多。

幽州北

不知道对不对
=SUMPRODUCT(COUNTIFS([data_all.xlsm]Sheet1!$B:$B,">="&$B3,[data_all.xlsm]Sheet1!$B:$B,"<"&$B4,[data_all.xlsm]Sheet1!H:H,{1,-1}))

蓝色蜡烛

上传个附件看看

北方的狼族

=SUMPRODUCT([data_all.xlsm]Sheet1!$B:$B>=$B3,[data_all.xlsm]Sheet1!$B:$B<$B4,ABS([data_all.xlsm]Sheet1!H:H)=1)

淡水河边的石榴

感谢大佬的解答。非常完美！

风从故乡来

=SUM(COUNTIFS([data_all.xlsm]Sheet1!$B:$B,">="&$B3,[data_all.xlsm]Sheet1!$B:$B,"<"&$B4,[data_all.xlsm]Sheet1!H:H)*{1,-1})

张志奇

也感谢其他热心解答的大佬和版主，感恩。因为数据不方便公开扩散，就不发上来了，望理解！

唯我逍遥

=SUMPRODUCT(COUNTIFS([data_all.xlsm]Sheet1!$B:$B,"<"&$B3:$B4,[data_all.xlsm]Sheet1!H:H,{1,-1})*{-1,-1;1,1})