求一个Excel公式,筛选工作表1中符合2项条件的值的总和,在工作表2中...答:这个问题好解,在表2的B2输入=SUMIFS(Sheet1!$C$2:$C$1000,Sheet1!$A$2:$A$1000,$A2,Sheet1!$B$2:$B$1000,"迟到"),C2输入=SUMIFS(Sheet1!$C$2:$C$1000,Sheet1!$A$2:$A$1000,$A2,Sheet1!$B$2:$B$1000,"早退"),D2输入=SUMIFS(Sheet1!$C$2:$C$1000,Sheet1!$A$2:...