EXCEL中根据已有月计划表格(日计划),打开表格时自动在一个单元格中累加当月1日到今天的计划数据总和?

2025-03-07 05:26:18
推荐回答(1个)
回答1:

=SUMIFS($B3:$BJ3,$B$2:$BJ$2,"计划",$B$1:$BJ$1,"<="&DAY(TODAY()))

=SUMIFS($C3:$BK3,$C$2:$BK$2,"实际",$B$1:$BJ$1,"<="&DAY(TODAY()))