Hi all!
I have a little problem here with a file I am working. On my workbook I have 6 sheets:
Sched, CM Report, Using Held Calls, Using Lunch, Held Calls and Lunch sheets.
On the Using Held Sheet and Using Lunch Sheet I have the names of my agents on Col A and on Col B-H are specific dates. For Cells B3:H15 I inserted a formula. Here is an example of the formula:
=IF(Sched!B3="y",SUMPRODUCT(('Held Calls'!$A$2:$A$343=$A3)*('Held Calls'!$B$2:$B$343=B$2)*(('Held Calls'!$C$2:$C$343))),"RD")
This formula works perfectly for Held Calls but on my Using Lunch it results to #VALUE. I have tried everything I know to have this resolved but I am stomped!
I attached here my worksheet to get a better picture of my issue if I failed totally in explaining it.
Thanks!
Bookmarks