分享程序员开发的那些事...
更新时间：2023-10-06 12:42:10
=DSUM({"x", "y"; A2:B}, "x", {"y"; FILTER(E2:E, E2:E<>"")})
=DSUM({"x", "y"; A2:B}, "x", {"y"; FILTER(D2:D, D2:D<>"")})
欧盟语法:
=DSUM({"x"; "y"\ A2:B}; "x"; {"y"\ FILTER(E2:E; E2:E<>"")}) =DSUM({"x"; "y"\ A2:B}; "x"; {"y"\ FILTER(D2:D; D2:D<>"")})