SumIf combination?

[cw1628]

Hello folks,

Hoping someone can give me a hand here with the following problem. I currently have a set of data in one tab:

Column A: Vendor #
Column B: wk 1 (sales)
Column C: wk 2 (sales)
Column D: wk 3 (sales)
etc
Column xxx: wk 52 (sales)

In another tab I have a column A for planned week for each vendor # and column B for revised week. Now my task is if this planned week changes, how much sales would have been impacted.

Ie.
Vendor AAA : Planned week 5. Revised week 10. Will sum column with week 5 to week 10.

Please see attachment for reference.

I'm just trying to find the easiest solution. Any advice/feedback is appreciated.