Values From A Closed Workbook

• 11-26-2012, 06:12 PM
crissy_c
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

• 11-27-2012, 03:08 AM
Bob Phillips
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.
• 11-27-2012, 04:36 PM
crissy_c
Oh sorry my bad, will post it to a new thread then.

Thanks:-)
• 11-27-2012, 04:56 PM
Bob Phillips
No, I have already done that for you. Post the workbook.
• 11-27-2012, 05:04 PM
crissy_c
thank you kindly;) here is my closed workbook
• 11-28-2012, 01:50 AM
Bob Phillips
```=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)```