My reading of the OP's question was that she wanted the B2 to change to B3
when copied downwards, in which case I would have thought not
=SUMPRODUCT(--(Data!$E$2:$E$1700=$B$2),--(Data!$Q$2:$Q$1700))
but
=SUMPRODUCT(--(Data!$E$2:$E$1700=$B2),--(Data!$Q$2:$Q$1700))
--
David Biddulph

"Pete_UK" wrote in message
...
I think you mean that you want to do this:

=SUMPRODUCT(--(Data!$E$2:$E$1700=$B$2),--(Data!$Q$2:$Q$1700))

No need for CSE when you enter it.

Hope this helps.

Pete

On Aug 27, 3:11 pm, Gina wrote:
I am currently using

=SUM(IF(Data!$E$2:$E$1700=2467,Data!$Q$2:$Q$1700,0 ))

But I would instead like to reference cell B2 of the current worksheet
rather than typing 2467. The reason being, I'd like to be able to drag
this
calculation down, and have the formula in the cell just below reference
cell
B3 of the current worksheet, etc.