炸了毛的猫
发表于 2021-12-14 19:43:14
=SUMPRODUCT((表1!A$2:A$9=A2)*(--TEXT(表1!B$2:B$9,"e")=B2)*(表1!C$2:C$9))
阿豹
发表于 2021-12-16 12:17:09
=SUMIFS(表1!C:C,表1!A:A,A2,表1!B:B,">="&DATE(B2,1,1),表1!B:B,"<"&DATE(B2+1,1,1))
太阳儿子
发表于 2021-12-19 03:50:18
=SUM(SUMIFS(表1!C:C,表1!A:A,A2,表1!B:B,"<"&DATE(B2,{1,13},1))*{-1,1})
破天子爵
发表于 2021-12-24 20:48:40
如果改成计数的方式 应该用什么公式
无锡楼市百科
发表于 2022-1-1 03:08:09
如果改成计数的方式 应该用什么公式
陈德红
发表于 2022-1-2 04:01:26
=COUNTIFS(表1!A:A,A2,表1!B:B,">="&DATE(B2,1,1),表1!B:B,"<"&DATE(B2+1,1,1))
哒咩
发表于 2022-1-6 21:43:13
=SUMPRODUCT((YEAR(表1!B$2:B$9)=B2)*(表1!A$2:A$9=A2))
老李哥
发表于 2022-1-9 01:49:34
=SUM(COUNTIFS(表1!A:A,A2,表1!B:B,"<"&DATE(B2,{1,13},1))*{-1,1})
忠哥归来
发表于 2022-1-10 21:33:50
=SUMPRODUCT(表1!C$2:C$9*(YEAR(表1!B$2:B$9)=B2)*(表1!A$2:A$9=A2))
小意
发表于 2022-1-16 04:23:34
=SUMPRODUCT((表1!A$2:A$9=A2)*(--TEXT(表1!B$2:B$9,"e")=B2)*(表1!C$2:C$9))