Results 1 to 2 of 2

Sumproduct using variable time

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-23-2007
    Location
    Suffolk, UK
    Posts
    298

    Sumproduct using variable time

    Hello,

    I have the following 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)))
    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.

    thanks reg
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1