LinkBack URL
About LinkBacks
Yes, add more SUMPRODUCT for weekday
=SUM($D$11:$AH$11)-AL4- SUMPRODUCT(SUMIF($D$10:$AH$10,Hol!$G$5:$G$7,$D$11:$AH$11)*(WEEKDAY(Hol!$G$5:$G$7,2)>5))- SUMPRODUCT(SUMIF($D$10:$AH$10,Hol!$G$5:$G$7,$D$11:$AH$11)*(WEEKDAY(Hol!$G$5:$G$7,2)<6))
Yes, add more SUMPRODUCT for weekday
=SUM($D$11:$AH$11)-AL4- SUMPRODUCT(SUMIF($D$10:$AH$10,Hol!$G$5:$G$7,$D$11:$AH$11)*(WEEKDAY(Hol!$G$5:$G$7,2)>5))- SUMPRODUCT(SUMIF($D$10:$AH$10,Hol!$G$5:$G$7,$D$11:$AH$11)*(WEEKDAY(Hol!$G$5:$G$7,2)<6))
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks