nevermind i figured out my mini error but thanks for the formula pete, worked
great!!!

"Tom" wrote:

Good help Pete, one more part to that. B2 in that formula should change by an
increment of 1 when the formula is copied down. for example, B2 starts as 11,
as the formula is copied down, B2 should then change to 12, 13, 14, etc. Any
thoughts?

"Pete_UK" wrote:

With the week numbers in column B of Sheet2 (assume starting in B2),
then put this formula in E2:

=SUMIF(Sheet1!B:B,B2,Sheet1!F:F)

then copy this down for as many numbers as you have in column B.

Hope this helps.

Pete

On Nov 6, 7:05 pm, Tom wrote:
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