J
Joe M.
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.
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.