I am using SUMPRODUCT to sum a column on another worksheet. My formula looks
like this:

=SUMPRODUCT((Data!$E$4:$E$10000=$A$1)*(Data!$H$4:$ H$10000=$A4)*(Data!$D$4:$D$10000="Y")*(Data!$J$4:$ J$10000="Y"))

The # of rows on worksheet DATA changes perodically. When I delete the rows
in DATA and paste in new rows the "to" reference changes to the same as the
"from" reference:

=SUMPRODUCT((Data!$E$4:$E$4=$A$1)*(Data!$H$4:$H$4= $A4)*(Data!$D$4:$D$4="Y")*(Data!$J$4:$J$4="Y"))

What can I do to keep my "to" reference at 10000?

Thanks,
Joe M.