Well, you certainly don't need to type it out each time - just copy it
down the column and the cell references will automatically adjust to
become:

=(IF(B41=Direct!E8,Direct!F8,0)+(IF(B41=Direct!E9, Direct!F9,0)))
=(IF(B42=Direct!E9,Direct!F9,0)+(IF(B42=Direct!E10 ,Direct!F10,0)))
=(IF(B43=Direct!E10,Direct!F10,0)+(IF(B43=Direct!E 11,Direct!F11,0)))
etc

Is that what you want to happen, or do you want to compare with B41
each time? If so, make it B$41 before copying down.

To copy the formula down, click on the cell containing it, click
<copy, then click on the cell below it, hold the <shift key down
while pressing <PageDown a few times until you get to row 250, then
release <shift and press <enter.

Hope this helps.

Pete