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.

Are there any sumproduct experts available who could steer me in the right
direction?

Gina