如图例:
V1=SUMPRODUCT(((U$1:U1>0)-(U$1:U1=0))*T$1:T1)
或=SUMIF(U$1:U1,">0",T$1:T1)-SUMIF(U$1:U1,"=0",T$1:T1)
下拉