Help with a formula to produce a cumulative target

Hi all,

I am trying to figure out a formula to add up the cumulative budgets for each sales person. I have a database of budgets as per below.

..........A..........B..........C..........D..........E..........F.........G
1..................JAN.......FEB.......MAR......APR.......MAY.....JUN
2.......BOB......100......150........100.......130.......100......100
3.......TIM......120......120........120.......120.......120......120
4.......KIM......100......100........100.......100.......100......100

On a second sheet I have a table which needs to show the cumulative sums as below:

..........A..........B
1..................MAR
2.......BOB......???
3.......TIM......???
4.......KIM......???

So need a formula to look up and sum JAN & FEB & MAR budgets for each sales person. I would like it so next month when i change MAR to APR in cell B1 it will automatically add JAN-APR and so on.

Hope that makes sense!!

I can't, its part of a larger report using 3 different databases.

Thanks for that, i am so close to applying to my actual sheet. the only question i have is... can you please explain how the section "-2,0,1" of the formula is applicable? I am following your formula to the tee, changing the reference cells and ranges to apply, however i am still getting #value!

I figured out what i was doing wrong, one of my reference cells was a merged cell, and it just wasnt reading it properly.

THANK YOU SO MUCH!!!