I am looking for a formula to take data from worksheet 1 column F based on
week number in column B and sum it in worksheet 2 column E. catch is that
there are a different number of entries for each week number in column B.

Example: worksheet 1

Column B Column F

11 120
11 156
11 98
12 256
12 179

worksheet 2
Column B Column E

11
should be 374
12
should be 435