Sum based on a match

[sandhya16]

i have a column containing 1 to 36 representing months(A2:A37) and i have one more cell(M1) in which i am calculating the month by taking difference between two dates.

So i want a formula that match M1 with A2:A37 value and based on match i want to add the column values(B2:B37) corresponding to match.

for eg. -if M1= 5 ,i want to get the sum from B7:B37 and so on depending on M1 value.if the value of M1 =0 then i want to sum from B2:B47.

Please help.

[XOR LX]

Hi.

Please re-read the forum rules, in particular that relating to cross-posting:

http://www.mrexcel.com/forum/excel-q...condition.html7

Regards

[sandhya16]

alright what do i need to do now?