合併格 总金额與付金额 (9751)

C3{=IF((A4>0)+(B4=0),TEXT(LOOKUP(9,0/A$3:A3,A$3:A3)-SUM((SUBTOTAL(2,OFFSET(A$3,,,ROW($1:1)))=COUNT(A$3:A3))*B$3:B3),"差0;多付0;支付完"),"")