S
Steve_C
I am trying to do a forcast sheet for one customer. Here is the genral
layout of the sheet I am pulling data from.
P/N QTY Ship Date
a 5 2/7/06
a 2 3/5/06
a 8 3/5/06
What I need is the sum of Part "a" by ship date. Here is what I am using
now. This works but does not sum the quantitys with the same ship date.
INDEX(INDIRECT("'"&$S$9&"'!$Q$2:$Q$5"),MATCH($Q11&"_"&$R11,INDIRECT("'"&$S$9&"'!$F$2:$F$5")&"_"&INDIRECT("'"&$S$9&"'!$P$2:$P$5"),0))
Thanks
Steve_C
layout of the sheet I am pulling data from.
P/N QTY Ship Date
a 5 2/7/06
a 2 3/5/06
a 8 3/5/06
What I need is the sum of Part "a" by ship date. Here is what I am using
now. This works but does not sum the quantitys with the same ship date.
INDEX(INDIRECT("'"&$S$9&"'!$Q$2:$Q$5"),MATCH($Q11&"_"&$R11,INDIRECT("'"&$S$9&"'!$F$2:$F$5")&"_"&INDIRECT("'"&$S$9&"'!$P$2:$P$5"),0))
Thanks
Steve_C