Hello Expert,
I don't understand why the following formula is not working. I tried server versions.
Would like an out put of only weekend Saturdays and another one for Sundays
Saturday
=SUMPRODUCT(--(HOUR([Report114.xls]Report1!$L$5:$L$50000)>=ROW(A1))*(HOUR([Report114.xls]Report1!$L$5:$L$50000)<ROW(A2))*([Report114.xls]Report1!$O$5:$O$50000="service_desk")*([Report114.xls]Report1!$F$5:$F$50000="Phone")*WEEKDAY([Report114.xls]Report1!$L$5:$L$50000)=6)
Sunday
=SUMPRODUCT(--(HOUR([Report114.xls]Report1!$L$5:$L$50000)>=ROW(A1))*(HOUR([Report114.xls]Report1!$L$5:$L$50000)<ROW(A2))*([Report114.xls]Report1!$O$5:$O$50000="service_desk")*([Report114.xls]Report1!$F$5:$F$50000="Phone")*WEEKDAY([Report114.xls]Report1!$L$5:$L$50000)=7)
I also tried >6 or >7 still no luck.
Thanks in advanced.
Bookmarks