![计算每周某天的 Excel 总和](https://linux22.com/image/1580788/%E8%AE%A1%E7%AE%97%E6%AF%8F%E5%91%A8%E6%9F%90%E5%A4%A9%E7%9A%84%20Excel%20%E6%80%BB%E5%92%8C.png)
答案1
使用以下公式C2
:
=IFERROR(IF(ISBLANK(A3),SUM(B$2:B2)-SUM(C$1:C1),IF(MATCH(A2,{"Mon","Tue","Wed","Thu","Fri","Sat","Sun"},)>MATCH(A3,{"Mon","Tue","Wed","Thu","Fri","Sat","Sun"},),SUM(B$2:B2)-SUM(C$1:C1),"")),"")
并填充下来
使用以下公式C2
:
=IFERROR(IF(ISBLANK(A3),SUM(B$2:B2)-SUM(C$1:C1),IF(MATCH(A2,{"Mon","Tue","Wed","Thu","Fri","Sat","Sun"},)>MATCH(A3,{"Mon","Tue","Wed","Thu","Fri","Sat","Sun"},),SUM(B$2:B2)-SUM(C$1:C1),"")),"")
并填充下来