總額 實際金額空白 取預算金額 (14041)

F2{=SUM(IF(C$2:C$16=0,B$2:B$16,C$2:C$16)*(A$2:A$16=E2))

另解{=SUM(TEXT(C$2:C$16,"0;;"&B$2:B$16)*(A$2:A$16=E2))



留言