crissy_c
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
CLOSED WORKBOOK:
IDWeekendSTOTO-C013/31/20124025B-C023/15/20124025
Help please?:dunno thanks!
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!