对满足某一年份的数据多条件求和

炸了毛的猫

=SUMPRODUCT((表1!A$2:A$9=A2)*(--TEXT(表1!B$2:B$9,"e")=B2)*(表1!C$2:C$9))

阿豹

=SUMIFS(表1!C:C,表1!A:A,A2,表1!B:B,">="&DATE(B2,1,1),表1!B:B,"<"&DATE(B2+1,1,1))

太阳儿子

=SUM(SUMIFS(表1!C:C,表1!A:A,A2,表1!B:B,"<"&DATE(B2,{1,13},1))*{-1,1})

破天子爵

如果改成计数的方式 应该用什么公式

无锡楼市百科

如果改成计数的方式 应该用什么公式

陈德红

=COUNTIFS(表1!A:A,A2,表1!B:B,">="&DATE(B2,1,1),表1!B:B,"<"&DATE(B2+1,1,1))

哒咩

=SUMPRODUCT((YEAR(表1!B$2:B$9)=B2)*(表1!A$2:A$9=A2))

老李哥

=SUM(COUNTIFS(表1!A:A,A2,表1!B:B,"<"&DATE(B2,{1,13},1))*{-1,1})

忠哥归来

=SUMPRODUCT(表1!C$2:C$9*(YEAR(表1!B$2:B$9)=B2)*(表1!A$2:A$9=A2))

小意

=SUMPRODUCT((表1!A$2:A$9=A2)*(--TEXT(表1!B$2:B$9,"e")=B2)*(表1!C$2:C$9))