I cannot seem to figure out why this formula below no loner works. It worked
prior to the following changes I have made

="1400" was changed to =$b$4 (where the number 1400 was placed in that cell
<"1500 was changed to <$B$5 (where the number 1500 was placed in that cell)


Thanks
=SUMPRODUCT(('[YTDTB ACTUAL ''09-10.xls]YTDTB99'!$A$3:$A$277=$B11)*('[YTDTB
ACTUAL ''09-10.xls]YTDTB99'!$D$1:$CI$1=B4)*('[YTDTB ACTUAL
''09-10.xls]YTDTB99'!$D$1:$CI$1<B5)*('[YTDTB ACTUAL
''09-10.xls]YTDTB99'!$D$3:$CI$277))+SUMPRODUCT(('[YTDTB ACTUAL
''09-10.xls]YTDTB99'!$A$3:$A$277=$A11)*('[YTDTB ACTUAL
''09-10.xls]YTDTB99'!$D$1:$CI$1=B4)*('[YTDTB ACTUAL
''09-10.xls]YTDTB99'!$D$1:$CI$1<B5)*('[YTDTB ACTUAL
''09-10.xls]YTDTB99'!$D$3:$CI$277))