输入後自动实现 (9165)

G8:G21=IF(LEFT(C8,FIND("-",C8)-1)=LEFT(C9,FIND("-",C9&"-")-1),"",SUM(D$8:D8)-SUM(G$7:G7))

I8:I21{=IF(H8="",INDEX(H9:H21,MATCH(1=1,H9:H21<>"",)),IFERROR(H8-G8,H8))