-
1 Attachment(s)
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?:dunno thanks!
-
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.
-
Oh sorry my bad, will post it to a new thread then.
Thanks:-)
-
No, I have already done that for you. Post the workbook.
-
1 Attachment(s)
thank you kindly;) here is my closed workbook
-
Use, with appropriately adjusted paths,
Code:
=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)