View Full Version : Values From A Closed Workbook

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


Help please?:dunno thanks!

Bob Phillips
11-27-2012, 03:08 AM

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
Oh sorry my bad, will post it to a new thread then.


Bob Phillips
11-27-2012, 04:56 PM
No, I have already done that for you. Post the workbook.

11-27-2012, 05:04 PM
thank you kindly;) here is my closed workbook

Bob Phillips
11-28-2012, 01:50 AM
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)