=COUNTIFS(表格1[次數],0,表格1[日期],">="&DATE(2023,2,1),表格1[日期],"<"&DATE(2023,3,1))
公式:
計數(判斷空(判斷月(判斷0)))
=COUNT(
IF(A:A="","",
IF(MONTH(A:A)=D2,
IF(B:B=0,B:B,""),
""))
)
D2:
=SUMPRODUCT((MONTH(A2:A10)=2)*(B2:B10=0)*1)