總和 二时段间的正数 (12022)

F3=SUMIFS(B:B,B:B,">0",A:A,">="&F1,A:A,"<="&F2)

B2:B24 格式化=COUNTIFS(B2,">0",A2,">="&F$1,A2,"<="&F$2)



留言