Consulting

Results 1 to 6 of 6

Thread: Values From A Closed Workbook

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Nov 2012
    Posts
    12
    Location
    hi guys

    Can someone help to have the correct sumproduct formula if i want to pull out value between a given date range with another criteria (all from a closed workbook).

    So for example, from my closed workbook, for ID O-C01, i want to pull out the 40(from ST column) and put it in my open workbook under the same column (ST) but only those dates falling between the date range given in the open workbook: 3/25/2012 to 4/25/2012


    CLOSED WORKBOOK:
    IDWeekendSTOTO-C013/31/20124025B-C023/15/20124025




    Help please? thanks!
    Attached Files Attached Files

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,438
    Location
    crissy,

    You must stop hijacking other people's threads. Just because it is on a similar topic, you should not add to it with a new question, start your own thread.

    Apart from being rude to the other poster to hijack a thread, it can backfire against you as some people will not look at a thread that is so active.

    As to your question. post the closed workbook as well so that we can see the structure.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Regular
    Joined
    Nov 2012
    Posts
    12
    Location
    Oh sorry my bad, will post it to a new thread then.

    Thanks:-)

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,438
    Location
    No, I have already done that for you. Post the workbook.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  5. #5
    VBAX Regular
    Joined
    Nov 2012
    Posts
    12
    Location
    thank you kindly here is my closed workbook
    Attached Files Attached Files

  6. #6
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,438
    Location
    Use, with appropriately adjusted paths,

    =SUMPRODUCT(('C:\Users\bob\Downloads\[closed wb.xls]closed'!$A$2:$A$3=$A4)
    *('C:\Users\bob\Downloads\[closed wb.xls]closed'!$C$1:$D$2=B$3)
    *('C:\Users\bob\Downloads\[closed wb.xls]closed'!$B$2:$B$3>=$B$1)
    *('C:\Users\bob\Downloads\[closed wb.xls]closed'!$B$2:$B$3<=$C$1)
    *'C:\Users\bob\Downloads\[closed wb.xls]closed'!$C$2:$D$3)
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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