This is a re-post of a problem from last week, hopefully someone can help...

Why does this formula return #VALUE:
=SUMPRODUCT(--(INDIRECT(INDEX($A$9:$A$72,$A$6)&"!B1:CW1")D$1),--(INDIRECT(INDEX($A$9:$A$72,$A$6)&"!B1:CW1")<E$1),I NDIRECT(ADDRESS(ROW(),COLUMN(B2),4,,(INDEX($A$9:$A $72,$A$6)))&":"&(ADDRESS(ROW(),COLUMN(CW2),4))))

When this formula works as expected:
=SUMPRODUCT(--(INDIRECT(INDEX($A$9:$A$72,$A$6)&"!B1:CW1")D$1),--(INDIRECT(INDEX($A$9:$A$72,$A$6)&"!B1:CW1")<E$1),I NDIRECT(INDEX($A$9:$A$72,$A$6)&"!B2:CW2"))

I cannot use the latter formula because I need to drag it down for each of
several thousand rows, and I would need to change "B2:CW2" manually for every
row.