I am able to pull through data with the formula posted below, however the
ranges need to be dynamic since the range is expanded daily. The ranges are
setup with range names. However, when I attempt to change the hard coded cell
references to range names, the formula retuens a #VALUE error.

=SUMPRODUCT(--(YEAR([LOB_ALT.xls]RAW_DATA!$A$2:$A$26496)=2007),--(MONTH([LOB_ALT.xls]RAW_DATA!$A$2:$A$26496)=10),[LOB_ALT.xls]RAW_DATA!$D$2:$D$26496)

The Range Names A
$A$2:$A$26496 = DATERANGE
$D$2:$D$26496 = VOLUME_ACT

HELP!!!

Thanks,
Ray