数组公式第一个=SUM((WEEKDAY(A2:AE2)=7)*IF(A4:AE4<8,A4:AE4/8,8))第二个=SUM((WEEKDAY(A2:AE2)=7)*IF(A4:AE4<8,0,A4:AE4-8))第三个=SUM((WEEKDAY(A2:AE2)=1)*A4:AE4)如不明白请追问
写代码来分析数据!