AG5=SUM(B5:AF5)-AH5-AI5AH5=SUMPRODUCT((WEEKDAY($B$3:$AF$3,2)>5)*(COUNTIF(节日,B$3:AF$3)=0)*B5:AF5)选择AG5:AH5复制并下拉，即可。
