Hello,
I have the following formula:
It counts the amount based on depot code & day, however, this lumps together the depot amounts if they are on the same day, so there is a time within the data that can differenciate the depots, but, the times may vary but not by more than +/- 1 hour 30 mins, I cannot seem to include the time varible in the formula.=SUMPRODUCT(($H$3:$H$6484=$A3)*(WEEKDAY($I$3:$I$6484)=VLOOKUP(B3,{"MON",2;"TUE",3;"WED",4;"THU",5;"FRI",6;"SAT",7},2,FALSE)))
thanks reg
Bookmarks