SUMPRODUCT With External Range Name?
You have text in your data, month and year return value errors if there is a
single text value in the range you are checking
--
Regards,
Peo Sjoblom
"RayportingMonkey" wrote in
message ...
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
|